APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 18: ,pay_element_entry_values_f eev

14: ,c_input_value_name VARCHAR2) IS
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

Line 38: lpayment_key pay_element_entry_values_f.screen_entry_value%TYPE;

34: AND pee.element_entry_id = eev.element_entry_id
35: AND peffective_date BETWEEN pee.effective_start_date
36: AND pee.effective_end_date ;
37: --
38: lpayment_key pay_element_entry_values_f.screen_entry_value%TYPE;
39: --
40: BEGIN
41: --
42: OPEN c_payment_key('Tax Details','Payment Key');

Line 1969: ,pay_element_entry_values_f peev

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
1973: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id