APPS.PAY_RETRO_PKG dependencies on PAY_INPUT_VALUES_F

Line 1423: SELECT /*+ INDEX(piv pay_input_values_f_pk)

1419: p_component_id in number,
1420: p_ele_set_id in number
1421: )
1422: is
1423: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1424: INDEX(pet pay_element_types_f_pk)
1425: USE_NL(piv pet) */
1426: pee.element_entry_id,
1427: pee.source_start_date,

Line 1440: pay_input_values_f piv,

1436: pepd.time_definition_id,
1437: pee.source_run_type,
1438: pee.assignment_id
1439: FROM pay_element_entries_f pee,
1440: pay_input_values_f piv,
1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,

Line 1444: pay_input_values_f piv1,

1440: pay_input_values_f piv,
1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,
1447: pay_retro_defn_components prdc2,
1448: pay_retro_defn_components prdc

Line 1526: SELECT /*+ INDEX(piv pay_input_values_f_pk)

1522: piv.input_value_id;
1523:
1524: ----
1525: cursor get_proc_retro_rrv IS -- Added for 7335351
1526: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1527: INDEX(pet pay_element_types_f_pk)
1528: USE_NL(piv pet) */
1529: pee.element_entry_id,
1530: pee.source_start_date,

Line 1542: pay_input_values_f piv,

1538: pepd.time_definition_id,
1539: pee.source_run_type,
1540: pee.assignment_id
1541: FROM pay_element_entries_f pee,
1542: pay_input_values_f piv,
1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,

Line 1546: pay_input_values_f piv1,

1542: pay_input_values_f piv,
1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,