DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PER_PEOPLE_EXTRA_INFO

Line 4181: FROM per_people_extra_info

4177: -- to get pensions staging date at Employee/Person level
4178: CURSOR C_EMP_PENSION_STAGING_DATE(P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
4179: IS
4180: SELECT pei_information1
4181: FROM per_people_extra_info
4182: WHERE pei_information_category LIKE 'GB_PENSIONS_STAGING_DATE'
4183: AND person_id = P_PERSON_ID;
4184:
4185: -- to get pensions staging date at Payee/Employer level