APPS.HR_BALANCE_FEEDS dependencies on PAY_RUN_RESULT_VALUES

Line 1562: pay_run_result_values rrv

1558: and scr.classification_id = bc.classification_id)))
1559: and exists
1560: (select null
1561: from pay_run_results rr,
1562: pay_run_result_values rrv
1563: where rrv.input_value_id = bf.input_value_id
1564: and rr.run_result_id = rrv.run_result_id
1565: and rr.status like 'P%');
1566: --

Line 1577: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null

1573: select 1
1574: from dual
1575: where exists
1576: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1577: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1578: from pay_run_result_values rrv,
1579: pay_run_results rr,
1580: pay_assignment_actions aa,
1581: pay_payroll_actions pa

Line 1578: from pay_run_result_values rrv,

1574: from dual
1575: where exists
1576: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1577: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1578: from pay_run_result_values rrv,
1579: pay_run_results rr,
1580: pay_assignment_actions aa,
1581: pay_payroll_actions pa
1582: where rrv.input_value_id = p_input_value_id

Line 1666: from pay_run_result_values rrv,

1662: and iv.effective_end_date
1663: and exists
1664: (select /*+ ORDERED*/
1665: null
1666: from pay_run_result_values rrv,
1667: pay_run_results rr,
1668: pay_assignment_actions aa,
1669: pay_payroll_actions pa
1670: where rrv.input_value_id = bf.input_value_id

Line 1689: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)

1685: from dual
1686: where
1687: exists (select /*+ FIRST_ROWS ORDERED
1688: USE_NL(rrv rr aa pa)
1689: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)
1690: INDEX(rr PAY_RUN_RESULTS_PK)
1691: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1692: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1693: */ 1

Line 1694: from pay_run_result_values rrv,

1690: INDEX(rr PAY_RUN_RESULTS_PK)
1691: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1692: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1693: */ 1
1694: from pay_run_result_values rrv,
1695: pay_run_results rr,
1696: pay_assignment_actions aa,
1697: pay_payroll_actions pa
1698: where rrv.input_value_id = p_input_value_id

Line 1727: from pay_run_result_values rrv

1723: select 1
1724: from dual
1725: where
1726: exists (select 1
1727: from pay_run_result_values rrv
1728: where rrv.input_value_id = p_input_value_id);
1729: --
1730: cursor csr_proc_feed_result
1731: (

Line 1740: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)

1736: from dual
1737: where
1738: exists (select /*+ FIRST_ROWS ORDERED
1739: USE_NL(rr aa rrv)
1740: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
1741: INDEX(rr PAY_RUN_RESULTS_N50)
1742: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)
1743: */ 1
1744: from pay_assignment_actions aa,

Line 1746: pay_run_result_values rrv

1742: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)
1743: */ 1
1744: from pay_assignment_actions aa,
1745: pay_run_results rr,
1746: pay_run_result_values rrv
1747: where rrv.input_value_id = p_input_value_id
1748: and rr.run_result_id = rrv.run_result_id
1749: and rr.status like 'P%'
1750: and aa.assignment_action_id = rr.assignment_action_id