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_ASSIGNMENT_ACTIONS

Line 1590: pay_assignment_actions aa,

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
1594: and rr.status like 'P%'

Line 1678: pay_assignment_actions aa,

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
1682: and rr.status like 'P%'

Line 1701: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)

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

Line 1706: pay_assignment_actions aa,

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
1710: and rr.status like 'P%'

Line 1752: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)

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

Line 1754: from pay_assignment_actions aa,

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,
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