1. Tables and Views for HCM
  2. HRM_PLANS_FOR_PERSON_SEC_V

HRM_PLANS_FOR_PERSON_SEC_V

Details

  • Schema: FUSION

  • Object owner: HRM

  • Object type: VIEW

Columns

Name

PERSON_ID

PLAN_ID

ENTERPRISE_ID

PLAN_NAME

PLAN_TYPE

STATUS

ACCESS_TYPE_CODE

JOB_ID

POSITION_ID

Query

SQL_Statement

SELECT PlanIncumbents.INCUMBENT_PERSON_ID PERSON_ID,

Plans.PLAN_ID,

Plans.ENTERPRISE_ID,

Plans.PLAN_NAME,

Plans.PLAN_TYPE,

Plans.STATUS,

Plans.ACCESS_TYPE_CODE,

Plans.JOB_ID,

Plans.POSITION_ID

FROM HRM_PLAN_INCUMBENTS PlanIncumbents, HRM_PLANS Plans

WHERE PlanIncumbents.PLAN_ID = Plans.PLAN_ID AND Plans.LATEST_RECORD_FLAG='Y'