eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BALANCE_FEEDS dependencies on PAY_RUN_RESULTS

Line 1561: from pay_run_results rr,

1557: and scr.element_type_id = iv.element_type_id
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%');

Line 1579: pay_run_results rr,

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
1583: and rr.run_result_id = rrv.run_result_id

Line 1667: pay_run_results rr,

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
1671: and rr.run_result_id = rrv.run_result_id

Line 1690: INDEX(rr PAY_RUN_RESULTS_PK)

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
1694: from pay_run_result_values rrv,

Line 1695: pay_run_results rr,

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
1699: and rr.run_result_id = rrv.run_result_id

Line 1741: INDEX(rr PAY_RUN_RESULTS_N50)

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,
1745: pay_run_results rr,

Line 1745: pay_run_results rr,

1741: INDEX(rr PAY_RUN_RESULTS_N50)
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%'