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 1580: pay_assignment_actions aa,

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

Line 1668: pay_assignment_actions aa,

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

Line 1691: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)

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

Line 1696: pay_assignment_actions aa,

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

Line 1742: INDEX(aa PAY_ASSIGNMENT_ACTIONS_N50)

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

Line 1744: from pay_assignment_actions aa,

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