APPS.PAY_SE_HOLIDAY_PAY dependencies on PER_PEOPLE_EXTRA_INFO

Line 68: FROM per_people_extra_info

64:
65: CURSOR csr_person_entitlement
66: IS
67: SELECT pei_information1
68: FROM per_people_extra_info
69: WHERE person_id = l_person_id
70: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
71:
72: CURSOR csr_legal_employer_entitlement

Line 493: FROM per_people_extra_info

489:
490: CURSOR csr_person_entitlement
491: IS
492: SELECT pei_information1
493: FROM per_people_extra_info
494: WHERE person_id = l_person_id
495: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
496:
497: CURSOR csr_legal_employer_entitlement

Line 875: FROM per_people_extra_info

871:
872: CURSOR csr_person_entitlement
873: IS
874: SELECT pei_information1
875: FROM per_people_extra_info
876: WHERE person_id = l_person_id
877: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
878:
879: CURSOR csr_legal_employer_entitlement

Line 1114: FROM per_people_extra_info

1110:
1111: CURSOR csr_person_limit
1112: IS
1113: SELECT pei_information3
1114: FROM per_people_extra_info
1115: WHERE person_id = l_person_id
1116: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
1117:
1118: CURSOR csr_legal_employer_limit

Line 1158: FROM per_people_extra_info

1154:
1155: CURSOR csr_person_entitlement
1156: IS
1157: SELECT pei_information1
1158: FROM per_people_extra_info
1159: WHERE person_id = l_person_id
1160: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
1161:
1162: CURSOR csr_legal_employer_entitlement

Line 1809: FROM per_people_extra_info

1805:
1806: CURSOR csr_person_entitlement
1807: IS
1808: SELECT pei_information1
1809: FROM per_people_extra_info
1810: WHERE person_id = l_person_id
1811: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
1812:
1813: CURSOR csr_legal_employer_entitlement

Line 2093: FROM per_people_extra_info

2089:
2090: CURSOR csr_person_entitlement
2091: IS
2092: SELECT pei_information1
2093: FROM per_people_extra_info
2094: WHERE person_id = l_person_id
2095: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
2096:
2097: CURSOR csr_legal_employer_entitlement

Line 2414: FROM per_people_extra_info

2410:
2411: CURSOR csr_person_entitlement
2412: IS
2413: SELECT pei_information1
2414: FROM per_people_extra_info
2415: WHERE person_id = l_person_id
2416: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
2417:
2418: CURSOR csr_legal_employer_entitlement

Line 2530: FROM per_people_extra_info

2526:
2527: CURSOR csr_person_entitlement
2528: IS
2529: SELECT pei_information1
2530: FROM per_people_extra_info
2531: WHERE person_id = l_person_id
2532: AND information_type = 'SE_PERSON_HOLIDAY_PAY_DETAILS';
2533:
2534: CURSOR csr_legal_employer_entitlement