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 150: pay_action_interlocks pai

146: CURSOR csr_get_aa_ids (p_prepay_aa_id NUMBER) IS
147: SELECT pai.locked_action_id
148: FROM pay_payroll_actions ppa,
149: pay_assignment_actions paa,
150: pay_action_interlocks pai
151: WHERE pai.locking_action_id = p_prepay_aa_id
152: AND paa.assignment_action_id = pai.locked_action_id
153: AND ppa.payroll_action_id = paa.payroll_action_id
154: AND ppa.action_type IN ('R', 'Q')

Line 164: pay_action_interlocks pai

160: CURSOR csr_get_prepay_id (p_run_id NUMBER) IS
161: SELECT pai.locking_action_id
162: FROM pay_payroll_actions ppa,
163: pay_assignment_actions paa,
164: pay_action_interlocks pai
165: WHERE pai.locked_action_id = p_run_id
166: AND paa.assignment_action_id = pai.locking_action_id
167: AND ppa.payroll_action_id = paa.payroll_action_id
168: AND ppa.action_type IN ('P', 'U');

Line 270: pay_action_interlocks pai

266: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
267: cp_assignment_id in number) is
268: select max(paa.assignment_action_id)
269: from pay_assignment_actions paa, -- assignment_action for master payroll run
270: pay_action_interlocks pai
271: where pai.locking_action_id = cp_prepay_action_id
272: and pai.locked_action_id = paa.assignment_action_id
273: and paa.assignment_id = cp_assignment_id
274: and paa.source_action_id is null -- master assignment_action

Line 582: FROM pay_action_interlocks pai,

578: RETURN boolean IS
579: --
580: CURSOR c_count_runs(p_asgact_id NUMBER) IS
581: SELECT pai.locking_action_id, count(pai2.locked_action_id)
582: FROM pay_action_interlocks pai,
583: pay_action_interlocks pai2,
584: pay_assignment_actions paa,
585: pay_payroll_actions ppa
586: WHERE pai.locked_action_id = p_asgact_id

Line 583: pay_action_interlocks pai2,

579: --
580: CURSOR c_count_runs(p_asgact_id NUMBER) IS
581: SELECT pai.locking_action_id, count(pai2.locked_action_id)
582: FROM pay_action_interlocks pai,
583: pay_action_interlocks pai2,
584: pay_assignment_actions paa,
585: pay_payroll_actions ppa
586: WHERE pai.locked_action_id = p_asgact_id
587: AND pai.locking_action_id = pai2.locking_action_id