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.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on PAY_RUN_RESULTS

Line 47: pay_run_results RR,

43: INTO l_balance
44: FROM
45: pay_run_result_values TARGET,
46: pay_balance_feeds_f FEED,
47: pay_run_results RR,
48: pay_payroll_actions PACT,
49: pay_assignment_actions ASSACT
50: WHERE ASSACT.assignment_id = p_assignment_id
51: AND ASSACT.payroll_action_id = PACT.payroll_action_id

Line 111: pay_run_results RR,

107: SELECT NVL(SUM(TARGET.result_value * FEED.scale),0)
108: INTO l_balance
109: FROM pay_run_result_values TARGET,
110: pay_balance_feeds_f FEED,
111: pay_run_results RR,
112: pay_payroll_actions PACT,
113: pay_assignment_actions ASSACT
114: WHERE ASSACT.assignment_id = p_assignment_id
115: AND ASSACT.payroll_action_id = PACT.payroll_action_id