APPS.PAY_SE_HOLIDAY_PAY dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 61: FROM per_assignment_extra_info

57: AND hoi4.org_information1 IS NOT NULL;*/
58: CURSOR csr_assignment_entitlement
59: IS
60: SELECT aei_information1
61: FROM per_assignment_extra_info
62: WHERE assignment_id = p_assignment_id
63: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
64:
65: CURSOR csr_person_entitlement

Line 486: FROM per_assignment_extra_info

482: AND hoi4.org_information1 IS NOT NULL;*/
483: CURSOR csr_assignment_entitlement
484: IS
485: SELECT aei_information1
486: FROM per_assignment_extra_info
487: WHERE assignment_id = p_assignment_id
488: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
489:
490: CURSOR csr_person_entitlement

Line 868: FROM per_assignment_extra_info

864:
865: CURSOR csr_assignment_entitlement
866: IS
867: SELECT aei_information1
868: FROM per_assignment_extra_info
869: WHERE assignment_id = p_assignment_id
870: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
871:
872: CURSOR csr_person_entitlement

Line 1107: FROM per_assignment_extra_info

1103:
1104: CURSOR csr_assignment_limit
1105: IS
1106: SELECT aei_information3
1107: FROM per_assignment_extra_info
1108: WHERE assignment_id = p_assignment_id
1109: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
1110:
1111: CURSOR csr_person_limit

Line 1151: FROM per_assignment_extra_info

1147:
1148: CURSOR csr_assignment_entitlement
1149: IS
1150: SELECT aei_information1
1151: FROM per_assignment_extra_info
1152: WHERE assignment_id = p_assignment_id
1153: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
1154:
1155: CURSOR csr_person_entitlement

Line 1802: FROM per_assignment_extra_info

1798:
1799: CURSOR csr_assignment_entitlement
1800: IS
1801: SELECT aei_information1
1802: FROM per_assignment_extra_info
1803: WHERE assignment_id = p_assignment_id
1804: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
1805:
1806: CURSOR csr_person_entitlement

Line 2086: FROM per_assignment_extra_info

2082:
2083: CURSOR csr_assignment_entitlement
2084: IS
2085: SELECT aei_information1
2086: FROM per_assignment_extra_info
2087: WHERE assignment_id = p_assignment_id
2088: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
2089:
2090: CURSOR csr_person_entitlement

Line 2407: FROM per_assignment_extra_info

2403:
2404: CURSOR csr_assignment_entitlement
2405: IS
2406: SELECT aei_information1
2407: FROM per_assignment_extra_info
2408: WHERE assignment_id = p_assignment_id
2409: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
2410:
2411: CURSOR csr_person_entitlement

Line 2523: FROM per_assignment_extra_info

2519:
2520: CURSOR csr_assignment_entitlement
2521: IS
2522: SELECT aei_information1
2523: FROM per_assignment_extra_info
2524: WHERE assignment_id = p_assignment_id
2525: AND information_type = 'SE_ASSIGN_HOLIDAY_PAY_DETAILS';
2526:
2527: CURSOR csr_person_entitlement