APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 92: ,per_All_assignments_f paaf

88: ,NVL(pcr.cont_information2,'N') single_parent
89: ,pcr.date_start date_start
90: FROM per_contact_relationships pcr
91: ,per_all_people_f pap
92: ,per_All_assignments_f paaf
93: WHERE paaf.assignment_id = passignment_id
94: AND pcr.person_id = paaf.person_id
95: AND pap.person_id = pcr.contact_person_id
96: AND pcr.rltd_per_rsds_w_dsgntr_flag = 'Y'

Line 360: ,per_all_assignments_f paaf

356: SELECT pap.marital_status
357: ,pap.person_id
358: ,paaf.assignment_number
359: FROM per_all_people_f pap
360: ,per_all_assignments_f paaf
361: WHERE paaf.assignment_id = passignment_id
362: AND pap.person_id = paaf.person_id
363: AND peffective_date BETWEEN pap.effective_start_date
364: AND pap.effective_end_date

Line 441: FROM per_all_assignments_f paaf

437: RETURN VARCHAR2 IS
438: --
439: CURSOR c_get_person_id IS
440: SELECT person_id
441: FROM per_all_assignments_f paaf
442: WHERE paaf.assignment_id = passignment_id
443: AND peffective_date BETWEEN paaf.effective_start_date
444: AND paaf.effective_end_date;
445: --

Line 595: ,per_All_assignments_f paaf

591: --
592: CURSOR cur_emp_address_chk IS
593: SELECT pa.Region_2
594: FROM per_addresses pa
595: ,per_All_assignments_f paaf
596: WHERE paaf.assignment_id = passignment_id
597: AND paaf.person_id = pa.person_id
598: AND pa.style IN('ES','ES_GLB')
599: AND pa.primary_flag = 'Y'

Line 609: ,per_All_assignments_f paaf

605: --
606: CURSOR cur_emp_loc_chk IS
607: SELECT pa.Region_2
608: FROM hr_locations pa
609: ,per_All_assignments_f paaf
610: WHERE paaf.assignment_id = passignment_id
611: AND paaf.location_id = pa.location_id
612: AND pa.style IN ('ES','ES_GLB')
613: AND peffective_date BETWEEN paaf.effective_start_date

Line 748: FROM per_all_assignments_f

744: --
745: CURSOR csr_assignment_start_date(c_assignment_id NUMBER
746: ,c_payroll_id NUMBER) IS
747: SELECT MIN(effective_start_date)
748: FROM per_all_assignments_f
749: WHERE assignment_id = c_assignment_id
750: AND payroll_id = c_payroll_id;
751:
752: CURSOR csr_payroll_end_date(c_payroll_id NUMBER

Line 1007: ,per_All_assignments_f paaf

1003: CURSOR csr_get_emp_name(C_payroll_action_id NUMBER
1004: ,c_effective_date DATE) IS
1005: SELECT pap.full_name
1006: FROM per_all_people_f pap
1007: ,per_All_assignments_f paaf
1008: ,pay_assignment_actions paa
1009: WHERE paa.payroll_action_id = c_payroll_action_id
1010: AND paa.assignment_id = paaf.assignment_id
1011: AND paaf.person_id = pap.person_id

Line 1093: ,per_all_assignments_f paaf

1089: ,paa.action_status
1090: ,prtf.shortname
1091: FROM pay_payroll_actions ppa
1092: ,pay_assignment_actions paa
1093: ,per_all_assignments_f paaf
1094: ,pay_run_types_f prtf
1095: WHERE ppa.payroll_action_id = p_payroll_action_id
1096: AND ppa.payroll_action_id = paa.payroll_action_id
1097: AND ppa.run_type_id = prtf.run_type_id

Line 1128: ,per_all_assignments_f paaf

1124: ,paaf.assignment_number
1125: ,hr_general.decode_lookup('MAR_STATUS',pap.marital_status) marital_status
1126: ,floor(months_between(c_effective_date,pap.date_of_birth)/12) Age
1127: FROM per_all_people_f pap
1128: ,per_all_assignments_f paaf
1129: WHERE pap.person_id = paaf.person_id
1130: AND paaf.assignment_id = c_assignment_id
1131: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date
1132: AND c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;

Line 1775: FROM per_all_assignments_f paaf

1771: CURSOR csr_get_work_center(c_assignment_id NUMBER
1772: ,c_effective_date DATE) IS
1773: SELECT scl.segment2
1774: ,paaf.person_id
1775: FROM per_all_assignments_f paaf
1776: ,hr_soft_coding_keyflex scl
1777: WHERE paaf.assignment_id = c_assignment_id
1778: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1779: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;

Line 1794: FROM per_all_assignments_f paaf

1790: CURSOR csr_get_assignment_id(c_person_id NUMBER
1791: ,c_effective_date DATE
1792: ,c_work_center NUMBER) IS
1793: SELECT paaf.assignment_id
1794: FROM per_all_assignments_f paaf
1795: ,hr_soft_coding_keyflex scl
1796: WHERE paaf.person_id = c_person_id
1797: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1798: AND scl.segment2 = c_work_center

Line 1897: ,per_all_assignments_f paaf

1893: CURSOR csr_get_contract_end_date(c_assignment_id NUMBER
1894: ,c_effective_date DATE) IS
1895: SELECT NVL(fnd_date.canonical_to_date(CTR_INFORMATION4),to_date('31-12-4712','dd-mm-yyyy')) Contract_End_Date
1896: FROM PER_CONTRACTS_f pcf
1897: ,per_all_assignments_f paaf
1898: WHERE paaf.assignment_id = c_assignment_id
1899: AND paaf.contract_id = pcf.contract_id
1900: AND pcf.ctr_information_category = 'ES'
1901: AND sysdate BETWEEN paaf.effective_start_date

Line 1938: FROM per_all_assignments_f paaf

1934: CURSOR csr_get_work_center(c_assignment_id NUMBER
1935: ,c_effective_date DATE) IS
1936: SELECT scl.segment2
1937: ,paaf.person_id
1938: FROM per_all_assignments_f paaf
1939: ,hr_soft_coding_keyflex scl
1940: WHERE paaf.assignment_id = c_assignment_id
1941: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1942: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;

Line 1966: FROM per_all_assignments_f paaf

1962: ,min(decode(piv.name, 'Amount', peev.screen_entry_value , null)) Amount
1963: ,min(decode(piv.name, 'Period Type', peev.screen_entry_value , null)) Period_type
1964: ,min(decode(piv.name, 'Start Date', peev.screen_entry_value , null)) Start_date
1965: ,min(decode(piv.name, 'End Date', peev.screen_entry_value , null)) End_date
1966: FROM per_all_assignments_f paaf
1967: ,hr_soft_coding_keyflex scl
1968: ,pay_element_entries_f pee
1969: ,pay_element_entry_values_f peev
1970: ,pay_element_types_f pet