DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PAY_INPUT_VALUES_F

Line 146: pay_input_values_f piv

142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv
147: WHERE pet.element_type_id = pel.element_type_id
148: AND pel.element_link_id = pee.element_link_id
149: AND pet.element_type_id = pete.element_type_id
150: AND pee.assignment_id = asg.assignment_id

Line 288: pay_input_values_f piv

284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv
289: WHERE pet.element_type_id = pel.element_type_id
290: AND pel.element_link_id = pee.element_link_id
291: AND pet.element_type_id = pete.element_type_id
292: AND peev.element_entry_id = pee.element_entry_id

Line 321: pay_input_values_f piv

317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv
322: WHERE pet.element_type_id = pel.element_type_id
323: AND pel.element_link_id = pee.element_link_id
324: AND pet.element_type_id = pete.element_type_id
325: AND peev.element_entry_id = pee.element_entry_id

Line 358: pay_input_values_f piv

354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv
359: WHERE pet.element_type_id = pel.element_type_id
360: AND pel.element_link_id = pee.element_link_id
361: AND pet.element_type_id = pete.element_type_id
362: AND peev.element_entry_id = pee.element_entry_id

Line 391: pay_input_values_f piv

387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv
392: WHERE pet.element_type_id = pel.element_type_id
393: AND pel.element_link_id = pee.element_link_id
394: AND pet.element_type_id = pete.element_type_id
395: AND peev.element_entry_id = pee.element_entry_id

Line 1544: pay_input_values_f piv

1540: IS
1541: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1542: max (decode (piv.name,'Reference', peev.screen_entry_value))
1543: FROM pay_element_entry_values_f peev,
1544: pay_input_values_f piv
1545: WHERE peev.element_entry_id = p_element_entry_id
1546: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1547: AND peev.input_value_id = piv.input_value_id
1548: AND piv.element_type_id = p_element_type_id

Line 1633: pay_input_values_f piv

1629: IS
1630: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1631: max (decode (piv.name,'Reference', peev.screen_entry_value))
1632: FROM pay_element_entry_values_f peev,
1633: pay_input_values_f piv
1634: WHERE peev.element_entry_id = p_element_entry_id
1635: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1636: AND peev.input_value_id = piv.input_value_id
1637: AND piv.element_type_id = p_element_type_id_o

Line 1650: pay_input_values_f piv ,

1646: SELECT nvl(prrv.result_value,'Unknown')
1647: FROM pay_run_results prr,
1648: pay_run_result_values prrv,
1649: pay_assignment_actions pac,
1650: pay_input_values_f piv ,
1651: pay_payroll_actions ppa
1652: WHERE prr.run_result_id = prrv.run_result_id
1653: AND prr.entry_type = 'E'
1654: AND PRR.source_type IN ('E', 'I')