APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 487: from pay_element_entry_values_f eev

483:
484: cursor get_override_elig is
485:
486: select nvl(eev.screen_entry_value, 'N')
487: from pay_element_entry_values_f eev
488: where eev.input_value_id = p_input_Value_id
489: and eev.element_entry_id = p_element_entry_id
490: and p_effective_date between eev.effective_Start_Date and eev.effective_end_date;
491:

Line 948: pay_element_entry_values_f peev,

944: pay_element_links_f pel,
945: pay_input_values_f piv,
946: pay_input_values_f piv1,
947: pay_input_values_f piv2,
948: pay_element_entry_values_f peev,
949: pay_element_entry_values_f peev1,
950: pay_element_entry_values_f peev2
951: where peef.assignment_id = c_assignment_id
952: and pet.element_name = 'ETP on Termination'

Line 949: pay_element_entry_values_f peev1,

945: pay_input_values_f piv,
946: pay_input_values_f piv1,
947: pay_input_values_f piv2,
948: pay_element_entry_values_f peev,
949: pay_element_entry_values_f peev1,
950: pay_element_entry_values_f peev2
951: where peef.assignment_id = c_assignment_id
952: and pet.element_name = 'ETP on Termination'
953: and pet.legislation_code = 'AU'

Line 950: pay_element_entry_values_f peev2

946: pay_input_values_f piv1,
947: pay_input_values_f piv2,
948: pay_element_entry_values_f peev,
949: pay_element_entry_values_f peev1,
950: pay_element_entry_values_f peev2
951: where peef.assignment_id = c_assignment_id
952: and pet.element_name = 'ETP on Termination'
953: and pet.legislation_code = 'AU'
954: and pet.element_type_id = pel.element_type_id

Line 2033: pay_element_entry_values_f peev

2029: select 1
2030: from pay_element_types_f pet,
2031: pay_input_values_f piv,
2032: pay_element_entries_f pee,
2033: pay_element_entry_values_f peev
2034: where pee.assignment_id = p_assignment_id
2035: and pet.element_type_id = piv.element_type_id
2036: and pet.element_name = 'ETP on Termination'
2037: and piv.name = 'Transitional ETP'