DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_INPUT_VALUES_F

Line 945: pay_input_values_f piv,

941: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
942: from pay_element_types_f pet,
943: pay_element_entries_f peef,
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,

Line 946: pay_input_values_f piv1,

942: from pay_element_types_f pet,
943: pay_element_entries_f peef,
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

Line 947: pay_input_values_f piv2,

943: pay_element_entries_f peef,
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

Line 1202: , pay_input_values_f pivf

1198: ,p_accrual_plan_id number
1199: ) is
1200: select to_number(hrl.description)
1201: from pay_element_types_f petf
1202: , pay_input_values_f pivf
1203: , pay_accrual_plans pap
1204: , hr_lookups hrl
1205: , pay_element_classifications pec
1206: where pap.accrual_plan_id = p_accrual_plan_id

Line 2031: pay_input_values_f piv,

2027:
2028: cursor csr_check_trans is
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