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

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

Line 1589: pay_run_results rr,

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

Line 1677: pay_run_results rr,

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

Line 1700: INDEX(rr PAY_RUN_RESULTS_PK)

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

Line 1705: pay_run_results rr,

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

Line 1751: INDEX(rr PAY_RUN_RESULTS_N50)

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

Line 1755: pay_run_results rr,

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