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_CA_BALANCE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 143: FROM pay_payroll_actions ppa,

139: RETURN NUMBER IS
140: --
141: CURSOR csr_get_aa_ids (p_prepay_aa_id NUMBER) IS
142: SELECT pai.locked_action_id
143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa,
145: pay_action_interlocks pai
146: WHERE pai.locking_action_id = p_prepay_aa_id
147: AND paa.assignment_action_id = pai.locked_action_id

Line 157: FROM pay_payroll_actions ppa,

153: and prt.run_type_id = paa.run_type_id );
154:
155: CURSOR csr_get_prepay_id (p_run_id NUMBER) IS
156: SELECT pai.locking_action_id
157: FROM pay_payroll_actions ppa,
158: pay_assignment_actions paa,
159: pay_action_interlocks pai
160: WHERE pai.locked_action_id = p_run_id
161: AND paa.assignment_action_id = pai.locking_action_id

Line 563: pay_payroll_actions ppa

559: SELECT pai.locking_action_id, count(pai2.locked_action_id)
560: FROM pay_action_interlocks pai,
561: pay_action_interlocks pai2,
562: pay_assignment_actions paa,
563: pay_payroll_actions ppa
564: WHERE pai.locked_action_id = p_asgact_id
565: AND pai.locking_action_id = pai2.locking_action_id
566: AND pai.locking_action_id = paa.assignment_action_id
567: AND paa.payroll_action_id = ppa.payroll_action_id