APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 19: ,pay_element_entries_f pee

15: SELECT eev.screen_entry_value payment_key
16: FROM pay_element_types_f pet
17: ,pay_input_values_f piv
18: ,pay_element_entry_values_f eev
19: ,pay_element_entries_f pee
20: WHERE pee.assignment_id = passignment_id
21: AND pee.element_type_id = pet.element_type_id
22: AND pet.element_name = c_element_name
23: AND pet.legislation_code = 'ES'

Line 667: FROM pay_element_entries_f pee

663: ,c_effective_date DATE) IS
664: SELECT 'Y'
665: FROM DUAL
666: WHERE EXISTS(SELECT 1
667: FROM pay_element_entries_f pee
668: ,pay_element_types_f pet
669: WHERE pee.assignment_id = c_assignment_id
670: AND pee.element_type_id = pet.element_type_id
671: AND pet.element_name = 'Tax Withholding Rate'

Line 1968: ,pay_element_entries_f pee

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
1972: WHERE paaf.person_id = c_person_id