APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 571: from pay_element_entry_values_f eev

567:
568: cursor get_override_elig is
569:
570: select nvl(eev.screen_entry_value, 'N')
571: from pay_element_entry_values_f eev
572: where eev.input_value_id = p_input_Value_id
573: and eev.element_entry_id = p_element_entry_id
574: and p_effective_date between eev.effective_Start_Date and eev.effective_end_date;
575:

Line 1044: pay_element_entry_values_f peev,

1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,
1046: pay_element_entry_values_f peev2
1047: where peef.assignment_id = c_assignment_id
1048: and pet.element_name = 'ETP on Termination'

Line 1045: pay_element_entry_values_f peev1,

1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,
1046: pay_element_entry_values_f peev2
1047: where peef.assignment_id = c_assignment_id
1048: and pet.element_name = 'ETP on Termination'
1049: and pet.legislation_code = 'AU'

Line 1046: pay_element_entry_values_f peev2

1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,
1046: pay_element_entry_values_f peev2
1047: where peef.assignment_id = c_assignment_id
1048: and pet.element_name = 'ETP on Termination'
1049: and pet.legislation_code = 'AU'
1050: and pet.element_type_id = pel.element_type_id

Line 2145: pay_element_entry_values_f peev

2141: select 1
2142: from pay_element_types_f pet,
2143: pay_input_values_f piv,
2144: pay_element_entries_f pee,
2145: pay_element_entry_values_f peev
2146: where pee.assignment_id = p_assignment_id
2147: and pet.element_type_id = piv.element_type_id
2148: and pet.element_name = 'ETP on Termination'
2149: and piv.name = 'Transitional ETP'

Line 2210: pay_element_entry_values_f peev

2206: select peev.screen_entry_value, count(peev.screen_entry_value) etp_no
2207: from pay_element_types_f pet,
2208: pay_input_values_f piv,
2209: pay_element_entries_f pee,
2210: pay_element_entry_values_f peev
2211: where pee.assignment_id = p_assignment_id
2212: and pet.element_type_id = piv.element_type_id
2213: and pet.element_name = 'ETP on Termination'
2214: and pet.legislation_code = 'AU'

Line 3232: pay_element_entry_values_f peev,

3228: per_all_assignments_f paa,
3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,

Line 3233: pay_element_entry_values_f peev1,

3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,

Line 3234: pay_element_entry_values_f peev2,

3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,
3238: pay_input_values_f piv2

Line 3327: pay_element_entry_values_f peev,

3323: select count(pee.element_entry_id)
3324: from pay_element_types_f pet,
3325: pay_input_values_f piv,
3326: pay_element_entries_f pee,
3327: pay_element_entry_values_f peev,
3328: pay_input_values_f piv2,
3329: pay_element_entry_values_f peev2
3330: where pee.assignment_id = p_assignment_id
3331: and pet.element_type_id = piv.element_type_id

Line 3329: pay_element_entry_values_f peev2

3325: pay_input_values_f piv,
3326: pay_element_entries_f pee,
3327: pay_element_entry_values_f peev,
3328: pay_input_values_f piv2,
3329: pay_element_entry_values_f peev2
3330: where pee.assignment_id = p_assignment_id
3331: and pet.element_type_id = piv.element_type_id
3332: and pet.element_name = 'ETP on Termination'
3333: and pet.element_type_id = pee.element_type_id