APPS.PAY_ES_TWR_CALC_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1776: ,hr_soft_coding_keyflex scl

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;
1780: --

Line 1795: ,hr_soft_coding_keyflex scl

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
1799: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;

Line 1939: ,hr_soft_coding_keyflex scl

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;
1943: --

Line 1967: ,hr_soft_coding_keyflex scl

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
1971: ,pay_input_values_f piv