DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on HR_GENERAL

Line 102: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_POSTPONEMENT_TYPE_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_POSTPONEMENT_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_POSTPONEMENT_TYPE ,

98: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_AGG_EARNINGS_PENSIONS_ID,SCREEN_ENTRY_VALUE, NULL)) G_AGG_EARNINGS_PENSIONS,
99: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_AUTO_ENROLLMENT_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_AUTO_ENROLLMENT_DATE ,
100: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_QUALIFYING_PS_EXISTS_ID,SCREEN_ENTRY_VALUE, NULL)) G_QUALIFYING_PS_EXISTS,
101: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_POSTPONEMENT_END_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_POSTPONEMENT_END_DATE,
102: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_POSTPONEMENT_TYPE_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_POSTPONEMENT_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_POSTPONEMENT_TYPE ,
103: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_WORKER_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_EMPLOYEE_CLASS,
104: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_IN_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_IN_DATE,
105: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_OUT_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_OUT_DATE,
106: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_OUT_END_DATE,

Line 103: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_WORKER_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_EMPLOYEE_CLASS,

99: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_AUTO_ENROLLMENT_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_AUTO_ENROLLMENT_DATE ,
100: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_QUALIFYING_PS_EXISTS_ID,SCREEN_ENTRY_VALUE, NULL)) G_QUALIFYING_PS_EXISTS,
101: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_POSTPONEMENT_END_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_POSTPONEMENT_END_DATE,
102: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_POSTPONEMENT_TYPE_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_POSTPONEMENT_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_POSTPONEMENT_TYPE ,
103: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID,HR_GENERAL.DECODE_LOOKUP('GB_PENSION_WORKER_TYPES',SCREEN_ENTRY_VALUE), NULL)) G_EMPLOYEE_CLASS,
104: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_IN_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_IN_DATE,
105: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_OUT_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_OUT_DATE,
106: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_OUT_END_DATE,
107: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_MAIN_ENTRY_ID,SCREEN_ENTRY_VALUE, NULL)) G_MAIN_ENTRY,