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_ACTION_INTERLOCKS

Line 145: pay_action_interlocks pai

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
148: AND ppa.payroll_action_id = paa.payroll_action_id
149: AND ppa.action_type IN ('R', 'Q')

Line 159: pay_action_interlocks pai

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
162: AND ppa.payroll_action_id = paa.payroll_action_id
163: AND ppa.action_type IN ('P', 'U');

Line 265: pay_action_interlocks pai

261: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
262: cp_assignment_id in number) is
263: select max(paa.assignment_action_id)
264: from pay_assignment_actions paa, -- assignment_action for master payroll run
265: pay_action_interlocks pai
266: where pai.locking_action_id = cp_prepay_action_id
267: and pai.locked_action_id = paa.assignment_action_id
268: and paa.assignment_id = cp_assignment_id
269: and paa.source_action_id is null -- master assignment_action

Line 560: FROM pay_action_interlocks pai,

556: RETURN boolean IS
557: --
558: CURSOR c_count_runs(p_asgact_id NUMBER) IS
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

Line 561: pay_action_interlocks pai2,

557: --
558: CURSOR c_count_runs(p_asgact_id NUMBER) IS
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