APPS.PAY_RETRO_PKG dependencies on PAY_INPUT_VALUES_F

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

1450: p_component_id in number,
1451: p_ele_set_id in number
1452: )
1453: is
1454: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1455: INDEX(pet pay_element_types_f_pk)
1456: USE_NL(piv pet) */
1457: pee.element_entry_id,
1458: pee.source_start_date,

Line 1471: pay_input_values_f piv,

1467: pepd.time_definition_id,
1468: pee.source_run_type,
1469: pee.assignment_id
1470: FROM pay_element_entries_f pee,
1471: pay_input_values_f piv,
1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,

Line 1475: pay_input_values_f piv1,

1471: pay_input_values_f piv,
1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,
1478: pay_retro_defn_components prdc2,
1479: pay_retro_defn_components prdc

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

1553: piv.input_value_id;
1554:
1555: ----
1556: cursor get_proc_retro_rrv IS -- Added for 7335351
1557: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1558: INDEX(pet pay_element_types_f_pk)
1559: USE_NL(piv pet) */
1560: pee.element_entry_id,
1561: pee.source_start_date,

Line 1575: pay_input_values_f piv,

1571: pepd.time_definition_id,
1572: pee.source_run_type,
1573: pee.assignment_id
1574: FROM pay_element_entries_f pee,
1575: pay_input_values_f piv,
1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,

Line 1579: pay_input_values_f piv1,

1575: pay_input_values_f piv,
1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,