APPS.HR_BALANCE_FEEDS dependencies on PAY_RUN_RESULT_VALUES

Line 1572: pay_run_result_values rrv

1568: and scr.classification_id = bc.classification_id)))
1569: and exists
1570: (select null
1571: from pay_run_results rr,
1572: pay_run_result_values rrv
1573: where rrv.input_value_id = bf.input_value_id
1574: and rr.run_result_id = rrv.run_result_id
1575: and rr.status like 'P%');
1576: --

Line 1587: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null

1583: select 1
1584: from dual
1585: where exists
1586: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1587: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1588: from pay_run_result_values rrv,
1589: pay_run_results rr,
1590: pay_assignment_actions aa,
1591: pay_payroll_actions pa

Line 1588: from pay_run_result_values rrv,

1584: from dual
1585: where exists
1586: (select /*+ ORDERED USE_NL(rrv rr aa pa)
1587: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1588: from pay_run_result_values rrv,
1589: pay_run_results rr,
1590: pay_assignment_actions aa,
1591: pay_payroll_actions pa
1592: where rrv.input_value_id = p_input_value_id

Line 1676: from pay_run_result_values rrv,

1672: and iv.effective_end_date
1673: and exists
1674: (select /*+ ORDERED*/
1675: null
1676: from pay_run_result_values rrv,
1677: pay_run_results rr,
1678: pay_assignment_actions aa,
1679: pay_payroll_actions pa
1680: where rrv.input_value_id = bf.input_value_id

Line 1699: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)

1695: from dual
1696: where
1697: exists (select /*+ FIRST_ROWS ORDERED
1698: USE_NL(rrv rr aa pa)
1699: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)
1700: INDEX(rr PAY_RUN_RESULTS_PK)
1701: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1702: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1703: */ 1

Line 1704: from pay_run_result_values rrv,

1700: INDEX(rr PAY_RUN_RESULTS_PK)
1701: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1702: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1703: */ 1
1704: from pay_run_result_values rrv,
1705: pay_run_results rr,
1706: pay_assignment_actions aa,
1707: pay_payroll_actions pa
1708: where rrv.input_value_id = p_input_value_id

Line 1737: from pay_run_result_values rrv

1733: select 1
1734: from dual
1735: where
1736: exists (select 1
1737: from pay_run_result_values rrv
1738: where rrv.input_value_id = p_input_value_id);
1739: --
1740: cursor csr_proc_feed_result
1741: (

Line 1750: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)

1746: from dual
1747: where
1748: exists (select /*+ FIRST_ROWS ORDERED
1749: USE_NL(rr aa rrv)
1750: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
1751: INDEX(rr PAY_RUN_RESULTS_N50)
1752: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)
1753: */ 1
1754: from pay_assignment_actions aa,

Line 1756: pay_run_result_values rrv

1752: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)
1753: */ 1
1754: from pay_assignment_actions aa,
1755: pay_run_results rr,
1756: pay_run_result_values rrv
1757: where rrv.input_value_id = p_input_value_id
1758: and rr.run_result_id = rrv.run_result_id
1759: and rr.status like 'P%'
1760: and aa.assignment_action_id = rr.assignment_action_id