PAY_CIR_RET_PLAN_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

RETIREMENT_PLAN_INSTANCE_ID RETIREMENT_PLAN_NAME EFFECTIVE_START_DATE EFFECTIVE_END_DATE DIR_CARD_ID PARENT_DIR_CARD_COMP_ID CREATOR_ID CREATOR_TYPE PAYROLL_RELATIONSHIP_ID PAYROLL_RELATIONSHIP_NUMBER ASSIGNMENT_NUMBER ASSIGNMENT_ID RETIREMENT_PLAN_ID VALUE_DEF_NAME1 VALUE_DEF_VALUE1 VALUE_DEF_NAME2 VALUE_DEF_VALUE2 VALUE_DEF_NAME3 VALUE_DEF_VALUE3 VALUE_DEF_NAME4 VALUE_DEF_VALUE4 VALUE_DEF_NAME5 VALUE_DEF_VALUE5 VALUE_DEF_NAME6 VALUE_DEF_VALUE6 VALUE_DEF_NAME7 VALUE_DEF_VALUE7 VALUE_DEF_NAME8 VALUE_DEF_VALUE8 VALUE_DEF_NAME9 VALUE_DEF_VALUE9 VALUE_DEF_NAME10 VALUE_DEF_VALUE10 VALUE_DEF_NAME11 VALUE_DEF_VALUE11 VALUE_DEF_NAME12 VALUE_DEF_VALUE12 VALUE_DEF_NAME13 VALUE_DEF_VALUE13 VALUE_DEF_NAME14 VALUE_DEF_VALUE14 VALUE_DEF_NAME15 VALUE_DEF_VALUE15 VALUE_DEF_NAME16 VALUE_DEF_VALUE16 VALUE_DEF_NAME17 VALUE_DEF_VALUE17 VALUE_DEF_NAME18 VALUE_DEF_VALUE18 VALUE_DEF_NAME19 VALUE_DEF_VALUE19 VALUE_DEF_NAME20 VALUE_DEF_VALUE20

Query

SQL_Statement

SELECT pdcc.DIR_CARD_COMP_ID RETIREMENT_PLAN_INSTANCE_ID, pdccd.BASE_COMPONENT_NAME RETIREMENT_PLAN_NAME, pdcc.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pdcc.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pdcc.DIR_CARD_ID, pdcc.PARENT_DIR_CARD_COMP_ID, pdcc.CREATOR_ID, pdcc.CREATOR_TYPE, pdc.PAYROLL_RELATIONSHIP_ID, prel.PAYROLL_RELATIONSHIP_NUMBER, assign.assignment_number ASSIGNMENT_NUMBER, assign.assignment_id ASSIGNMENT_ID, pdccd.dir_card_comp_def_id RETIREMENT_PLAN_ID, null VALUE_DEF_NAME1, null VALUE_DEF_VALUE1, null VALUE_DEF_NAME2, null VALUE_DEF_VALUE2, null VALUE_DEF_NAME3, null VALUE_DEF_VALUE3, null VALUE_DEF_NAME4, null VALUE_DEF_VALUE4, null VALUE_DEF_NAME5, null VALUE_DEF_VALUE5, null VALUE_DEF_NAME6, null VALUE_DEF_VALUE6, null VALUE_DEF_NAME7, null VALUE_DEF_VALUE7, null VALUE_DEF_NAME8, null VALUE_DEF_VALUE8, null VALUE_DEF_NAME9, null VALUE_DEF_VALUE9, null VALUE_DEF_NAME10, null VALUE_DEF_VALUE10, null VALUE_DEF_NAME11, null VALUE_DEF_VALUE11, null VALUE_DEF_NAME12, null VALUE_DEF_VALUE12, null VALUE_DEF_NAME13, null VALUE_DEF_VALUE13, null VALUE_DEF_NAME14, null VALUE_DEF_VALUE14, null VALUE_DEF_NAME15, null VALUE_DEF_VALUE15, null VALUE_DEF_NAME16, null VALUE_DEF_VALUE16, null VALUE_DEF_NAME17, null VALUE_DEF_VALUE17, null VALUE_DEF_NAME18, null VALUE_DEF_VALUE18, null VALUE_DEF_NAME19, null VALUE_DEF_VALUE19, null VALUE_DEF_NAME20, null VALUE_DEF_VALUE20 FROM pay_dir_card_definitions_vl pdcd, PAY_DIR_CARDS_F pdc, PAY_DIR_CARD_COMPONENTS_F pdcc, PAY_DIR_CARD_COMP_DEFS_F pdccd, per_legislative_data_groups_vl ldg, pay_pay_relationships_dn prel, pay_rel_groups_dn assign where pdcd.DIR_CARD_DEFINITION_ID=pdc.DIR_CARD_DEFINITION_ID and pdcd.base_display_name = 'ORA_RET_RETIREMENT_PLANS' and pdc.DIR_CARD_ID=pdcc.DIR_CARD_ID and pdccd.DIR_CARD_COMP_DEF_ID = pdcc.DIR_CARD_COMP_DEF_ID and ldg.legislative_data_group_id = pdc.legislative_data_group_id and pdccd.element_type_id is not null and prel.payroll_relationship_id= pdc.payroll_relationship_id and assign.payroll_relationship_id = prel.payroll_relationship_id and assign.group_type = 'A'