APPS.PAY_NL_REM_REPORT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 961: FROM per_assignment_extra_info

957: CURSOR to fetch NUM IV override
958: ***********************************************************/
959: CURSOR cur_numiv_override(c_asg_id NUMBER) is
960: SELECT aei_information1 numiv_override
961: FROM per_assignment_extra_info
962: WHERE assignment_id = c_asg_id
963: AND aei_information_category = 'NL_NUMIV_OVERRIDE';
964: --=============================================================================
965: CURSOR csr_le_hr_mapping_chk IS

Line 1071: FROM per_assignment_extra_info paei

1067: CURSOR cur_get_lhd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1068: SELECT paei.aei_information3 lhd_type
1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from
1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei
1072: WHERE paei.aei_information_category = 'NL_LHI'
1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date
1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1075: AND paei.assignment_id = c_assignment_id

Line 1086: FROM per_assignment_extra_info paei

1082: CURSOR cur_get_ttd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1083: SELECT paei.aei_information3 ttd_type
1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from
1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei
1087: WHERE paei.aei_information_category = 'NL_TTD'
1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date
1089: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1090: AND paei.assignment_id = c_assignment_id