APPS.PAY_ZA_TAX_REG_AR dependencies on PAY_ASSIGNMENT_ACTIONS

Line 174: pay_assignment_actions paa3,

170: AND ptp.payroll_id = PAF.payroll_id
171: and p_period_end_date between ptp.start_date and ptp.end_date
172: AND exists
173: ( select 1 from
174: pay_assignment_actions paa3,
175: pay_payroll_actions ppa2
176: where paa3.assignment_id = PAF.assignment_id
177: and paa3.payroll_action_id = ppa2.payroll_action_id
178: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')

Line 191: l_ass_act_id pay_assignment_actions.assignment_action_id%type;

187: );
188:
189: l_proc constant varchar2(80) := g_package ||'action_creation';
190:
191: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
192:
193: leg_param pay_payroll_actions.legislative_parameters%type;
194:
195: begin

Line 234: select pay_assignment_actions_s.nextval

230: g_end_period_date,
231: g_inc_all_asg) = 'Y') THEN
232: hr_utility.set_location('Incl Assignment ID:'||v_assignments.assignment_id,30);
233:
234: select pay_assignment_actions_s.nextval
235: into l_ass_act_id
236: from dual;
237:
238: -- insert into pay_assignment_actions.

Line 238: -- insert into pay_assignment_actions.

234: select pay_assignment_actions_s.nextval
235: into l_ass_act_id
236: from dual;
237:
238: -- insert into pay_assignment_actions.
239: hr_nonrun_asact.insact(l_ass_act_id,
240: v_assignments.assignment_id,
241: pactid,
242: chunk,

Line 315: l_asg_id pay_assignment_actions.assignment_id%type;

311: p_effective_date in date)
312: is
313: l_proc constant varchar2(80) := g_package ||'archive_code';
314:
315: l_asg_id pay_assignment_actions.assignment_id%type;
316:
317: l_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
318: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
319: l_period_num per_time_periods.period_num%TYPE;

Line 341: pay_assignment_actions paa

337: -- Retrieve legislative parameters from the archiver payroll action
338: select ppa.legislative_parameters, ppa.payroll_action_id
339: into leg_param, l_payroll_action_id
340: from pay_payroll_actions ppa,
341: pay_assignment_actions paa
342: where paa.payroll_action_id = ppa.payroll_action_id
343: and paa.assignment_action_id = p_assactid;
344:
345: hr_utility.set_location('leg_param:'||leg_param,20);

Line 365: from pay_assignment_actions

361:
362:
363: select assignment_id
364: into l_asg_id
365: from pay_assignment_actions
366: where assignment_action_id = p_assactid;
367:
368:
369: select ptp.prd_information1,PAF.payroll_id, ptp.time_period_id, ptp.prd_information2, ptp.pay_advice_date

Line 372: ,pay_assignment_actions paa

368:
369: select ptp.prd_information1,PAF.payroll_id, ptp.time_period_id, ptp.prd_information2, ptp.pay_advice_date
370: into g_tax_year, g_payroll_id, g_end_period_id, l_qtr_num, l_pay_advice_date
371: from per_time_periods ptp
372: ,pay_assignment_actions paa
373: ,per_assignments_f PAF
374: where paa.assignment_action_id = p_assactid
375: and PAF.assignment_id = paa.assignment_id
376: and ptp.payroll_id = PAF.payroll_id

Line 499: , pay_assignment_actions paa

495: ppf.payroll_name payroll_name,
496: ptp.start_date start_date,
497: ptp.end_date end_date
498: from pay_payroll_actions ppa
499: , pay_assignment_actions paa
500: , pay_action_information pai
501: , pay_all_payrolls_f ppf
502: , per_time_periods ptp
503: where ppa.payroll_action_id = pactid

Line 634: ,pay_assignment_actions paa

630: /*
631: SELECT count( DISTINCT pai.action_information3)
632: INTO CP_Total_Employees
633: FROM pay_action_information pai
634: ,pay_assignment_actions paa
635: WHERE pai.action_context_id = paa.assignment_action_id
636: AND paa.payroll_action_id = p_payroll_action_id;
637:
638: SELECT count( DISTINCT pai.action_information11)

Line 641: ,pay_assignment_actions paa

637:
638: SELECT count( DISTINCT pai.action_information11)
639: INTO CP_Total_Assignments
640: FROM pay_action_information pai
641: ,pay_assignment_actions paa
642: WHERE pai.action_context_id = paa.assignment_action_id
643: AND paa.payroll_action_id = p_payroll_action_id;
644: */
645:

Line 660: FROM pay_assignment_actions

656: FROM pay_action_information
657: WHERE action_context_id in
658: (
659: SELECT assignment_action_id
660: FROM pay_assignment_actions
661: WHERE payroll_action_id = p_payroll_action_id
662: )
663: AND action_information_category = 'ZA_TAX_REG_REP';
664:

Line 671: FROM pay_assignment_actions

667: WHERE action_context_id = p_payroll_action_id
668: AND action_information_category = 'ZA_TAX_REG_REP_PAY_DET';
669:
670: DELETE
671: FROM pay_assignment_actions
672: WHERE payroll_action_id = p_payroll_action_id;
673:
674: DELETE
675: FROM pay_payroll_actions