APPS.PAY_CA_BALANCE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 144: pay_assignment_actions paa,

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
148: AND ppa.payroll_action_id = paa.payroll_action_id

Line 158: pay_assignment_actions paa,

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
162: AND ppa.payroll_action_id = paa.payroll_action_id

Line 167: FROM pay_assignment_actions paa

163: AND ppa.action_type IN ('P', 'U');
164:
165: CURSOR csr_check_sep_chk (p_run_aa_id NUMBER) IS
166: SELECT 1
167: FROM pay_assignment_actions paa
168: , pay_run_types_f prt
169: WHERE paa.assignment_action_id = p_run_aa_id
170: and prt.legislation_code = 'CA'
171: and prt.run_method = 'S'

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

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

Line 454: FROM pay_assignment_actions paa

450: SELECT DECODE(prt.shortname,'SEP_PAY','Y','N'),
451: paa.assignment_id
452: INTO l_sep_check,
453: l_assignment_id
454: FROM pay_assignment_actions paa
455: ,pay_run_types_f prt
456: WHERE paa.assignment_action_id = p_assignment_action_id
457: AND prt.run_type_id = paa.run_type_id
458: AND prt.legislation_code = 'CA';

Line 471: from pay_assignment_actions paa_master

467:
468: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
469: select paa_master.source_action_id
470: into l_assignment_action_id
471: from pay_assignment_actions paa_master
472: ,pay_assignment_actions paa_sm
473: where paa_sm.assignment_action_id = p_assignment_action_id
474: and paa_master.assignment_action_id = paa_sm.source_action_id;
475: ELSE

Line 472: ,pay_assignment_actions paa_sm

468: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
469: select paa_master.source_action_id
470: into l_assignment_action_id
471: from pay_assignment_actions paa_master
472: ,pay_assignment_actions paa_sm
473: where paa_sm.assignment_action_id = p_assignment_action_id
474: and paa_master.assignment_action_id = paa_sm.source_action_id;
475: ELSE
476: select paa.source_action_id

Line 478: from pay_assignment_actions paa

474: and paa_master.assignment_action_id = paa_sm.source_action_id;
475: ELSE
476: select paa.source_action_id
477: into l_assignment_action_id
478: from pay_assignment_actions paa
479: where paa.assignment_action_id = p_assignment_action_id;
480: END IF;
481:
482: IF nvl(l_jd_context,'Not_Set') = 'Not_Set' THEN

Line 562: pay_assignment_actions paa,

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