APPS.PAY_CA_BALANCE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 149: pay_assignment_actions paa,

145: --
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

Line 163: pay_assignment_actions paa,

159:
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

Line 172: FROM pay_assignment_actions paa

168: AND ppa.action_type IN ('P', 'U');
169:
170: CURSOR csr_check_sep_chk (p_run_aa_id NUMBER) IS
171: SELECT 1
172: FROM pay_assignment_actions paa
173: , pay_run_types_f prt
174: WHERE paa.assignment_action_id = p_run_aa_id
175: and prt.legislation_code = 'CA'
176: and prt.run_method = 'S'

Line 269: from pay_assignment_actions paa, -- assignment_action for master payroll run

265:
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

Line 476: FROM pay_assignment_actions paa

472: SELECT DECODE(prt.shortname,'SEP_PAY','Y','N'),
473: paa.assignment_id
474: INTO l_sep_check,
475: l_assignment_id
476: FROM pay_assignment_actions paa
477: ,pay_run_types_f prt
478: WHERE paa.assignment_action_id = p_assignment_action_id
479: AND prt.run_type_id = paa.run_type_id
480: AND prt.legislation_code = 'CA';

Line 493: from pay_assignment_actions paa_master

489:
490: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
491: select paa_master.source_action_id
492: into l_assignment_action_id
493: from pay_assignment_actions paa_master
494: ,pay_assignment_actions paa_sm
495: where paa_sm.assignment_action_id = p_assignment_action_id
496: and paa_master.assignment_action_id = paa_sm.source_action_id;
497: ELSE

Line 494: ,pay_assignment_actions paa_sm

490: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
491: select paa_master.source_action_id
492: into l_assignment_action_id
493: from pay_assignment_actions paa_master
494: ,pay_assignment_actions paa_sm
495: where paa_sm.assignment_action_id = p_assignment_action_id
496: and paa_master.assignment_action_id = paa_sm.source_action_id;
497: ELSE
498: select paa.source_action_id

Line 500: from pay_assignment_actions paa

496: and paa_master.assignment_action_id = paa_sm.source_action_id;
497: ELSE
498: select paa.source_action_id
499: into l_assignment_action_id
500: from pay_assignment_actions paa
501: where paa.assignment_action_id = p_assignment_action_id;
502: END IF;
503:
504: IF nvl(l_jd_context,'Not_Set') = 'Not_Set' THEN

Line 584: pay_assignment_actions paa,

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
588: AND pai.locking_action_id = paa.assignment_action_id