APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 137: from pay_payroll_actions

133: ) + length(p_token)
134: )
135: ),
136: business_group_id
137: from pay_payroll_actions
138: where payroll_action_id = p_pact_id;
139:
140: l_business_group_id varchar2(20);
141: l_token_value varchar2(50);

Line 205: from pay_payroll_actions ppa2

201: select substr(
202: max(lpad(paa2.action_sequence, 15, 0) || paa2.rowid)
203: , -length(paa2.rowid)
204: )
205: from pay_payroll_actions ppa2
206: , pay_assignment_actions paa2
207: where paa2.assignment_id = p_assignment_id
208: and ppa2.payroll_action_id = paa2.payroll_action_id
209: and ppa2.action_type in ('R', 'Q', 'I', 'B', 'V')

Line 325: , pay_payroll_actions ppa

321: and not exists
322: (
323: select null
324: from pay_action_information pai
325: , pay_payroll_actions ppa
326: where pai.action_context_type = 'PA'
327: and pai.action_information_category = 'ZA UIF CREATOR DETAILS'
328: and pai.action_information1 = g_business_group_id
329: and pai.action_information2 = to_char(g_canonical_end_date, 'YYYYMM')

Line 336: from pay_payroll_actions

332: */
333:
334: cursor csr_archive_effective_date(pactid number) is
335: select effective_date
336: from pay_payroll_actions
337: where payroll_action_id = pactid;
338:
339: l_payroll_id number;
340: l_start_date varchar2(30);

Line 383: update pay_payroll_actions

379: p_token_value => l_payroll_id
380: );
381:
382: -- Update the payroll_id column on the Payroll_Action record.
383: update pay_payroll_actions
384: set payroll_id = l_payroll_id
385: where payroll_action_id = pactid;
386:
387:

Line 390: from pay_payroll_actions

386:
387:
388: select get_parameter('START_DATE', legislative_parameters)
389: into l_start_date
390: from pay_payroll_actions
391: where payroll_action_id = pactid;
392:
393: select get_parameter('END_DATE', legislative_parameters)
394: into l_end_date

Line 395: from pay_payroll_actions

391: where payroll_action_id = pactid;
392:
393: select get_parameter('END_DATE', legislative_parameters)
394: into l_end_date
395: from pay_payroll_actions
396: where payroll_action_id = pactid;
397:
398: select get_parameter('BG_ID', legislative_parameters)
399: into l_bg_id

Line 400: from pay_payroll_actions

396: where payroll_action_id = pactid;
397:
398: select get_parameter('BG_ID', legislative_parameters)
399: into l_bg_id
400: from pay_payroll_actions
401: where payroll_action_id = pactid;
402:
403: select get_parameter('ASG_SET_ID', legislative_parameters)
404: into g_asg_set_id

Line 405: from pay_payroll_actions

401: where payroll_action_id = pactid;
402:
403: select get_parameter('ASG_SET_ID', legislative_parameters)
404: into g_asg_set_id
405: from pay_payroll_actions
406: where payroll_action_id = pactid;
407:
408: select get_parameter('PERSON_ID', legislative_parameters)
409: into g_person_id

Line 410: from pay_payroll_actions

406: where payroll_action_id = pactid;
407:
408: select get_parameter('PERSON_ID', legislative_parameters)
409: into g_person_id
410: from pay_payroll_actions
411: where payroll_action_id = pactid;
412:
413: g_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
414: g_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');

Line 486: pay_payroll_actions ppa

482: sql_range :=
483: 'select distinct asg.person_id
484: from per_assignments_f asg,
485: pay_payrolls_f ppf,
486: pay_payroll_actions ppa
487: where ppa.payroll_action_id = :payroll_action_id
488: and asg.business_group_id = ppa.business_group_id
489: and asg.assignment_type = ''E''
490: and ppf.payroll_id = asg.payroll_id

Line 536: pay_payroll_actions ppa

532: sql_range :=
533: 'select distinct asg.person_id
534: from per_assignments_f asg,
535: pay_payrolls_f ppf,
536: pay_payroll_actions ppa
537: where ppa.payroll_action_id = :payroll_action_id
538: and asg.business_group_id = ppa.business_group_id
539: and asg.assignment_type = ''E''
540: and ppf.payroll_id = asg.payroll_id

Line 590: pay_payroll_actions ppa_arch,

586: asg.assignment_id assignment_id
587: from per_assignments_f asg,
588: per_assignments_f asg3,
589: --pay_payrolls_f ppf, -- Bug 2608190
590: pay_payroll_actions ppa_arch,
591: per_assignment_extra_info paei,
592: per_periods_of_service pds -- Bug 2654703
593: where asg.business_group_id = ppa_arch.business_group_id
594: and asg.period_of_service_id = pds.period_of_service_id -- Bug 2608190

Line 654: ,pay_payroll_actions ppa_arch

650: ,paa.assignment_id
651: from per_all_people_f ppf
652: ,per_all_assignments_f paa
653: ,per_assignment_extra_info paei
654: ,pay_payroll_actions ppa_arch
655: ,per_periods_of_service pps
656: where paa.business_group_id = ppa_arch.business_group_id
657: and paa.person_id = ppf.person_id
658: and ppf.person_id between p_stperson and p_endperson /* to select all Employees in a payroll run */

Line 709: leg_param pay_payroll_actions.legislative_parameters%type;

705: l_payroll_id number;
706: l_consolidation_set number;
707: l_assignment_set_id number;
708:
709: leg_param pay_payroll_actions.legislative_parameters%type;
710: asg_include boolean;
711: lockingactid number;
712: v_incl_sw hr_assignment_set_amendments.include_or_exclude%type;
713:

Line 735: from pay_payroll_actions

731: hr_utility.set_location('Entering ' || l_proc, 10);
732:
733: select get_parameter('START_DATE', legislative_parameters)
734: into l_start_date
735: from pay_payroll_actions
736: where payroll_action_id = pactid;
737:
738: select get_parameter('END_DATE', legislative_parameters)
739: into l_end_date

Line 740: from pay_payroll_actions

736: where payroll_action_id = pactid;
737:
738: select get_parameter('END_DATE', legislative_parameters)
739: into l_end_date
740: from pay_payroll_actions
741: where payroll_action_id = pactid;
742:
743: select get_parameter('BG_ID', legislative_parameters)
744: into l_bg_id

Line 745: from pay_payroll_actions

741: where payroll_action_id = pactid;
742:
743: select get_parameter('BG_ID', legislative_parameters)
744: into l_bg_id
745: from pay_payroll_actions
746: where payroll_action_id = pactid;
747:
748: select get_parameter('ASG_SET_ID', legislative_parameters)
749: into l_asg_set_id

Line 750: from pay_payroll_actions

746: where payroll_action_id = pactid;
747:
748: select get_parameter('ASG_SET_ID', legislative_parameters)
749: into l_asg_set_id
750: from pay_payroll_actions
751: where payroll_action_id = pactid;
752:
753: select get_parameter('PERSON_ID', legislative_parameters)
754: into l_person_id

Line 755: from pay_payroll_actions

751: where payroll_action_id = pactid;
752:
753: select get_parameter('PERSON_ID', legislative_parameters)
754: into l_person_id
755: from pay_payroll_actions
756: where payroll_action_id = pactid;
757:
758: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
759: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');

Line 1122: from pay_payroll_actions ppa,

1118: select ppa.effective_date,
1119: ppa.payroll_action_id
1120: into l_archive_effective_date,
1121: l_pactid --Bug 4134166
1122: from pay_payroll_actions ppa,
1123: pay_assignment_actions paa
1124: where paa.payroll_action_id = ppa.payroll_action_id
1125: and paa.assignment_action_id = p_assactid;
1126:

Line 1624: token_val pay_payroll_actions.legislative_parameters%type;

1620: ) return varchar2 is
1621:
1622: start_ptr number;
1623: end_ptr number;
1624: token_val pay_payroll_actions.legislative_parameters%type;
1625: par_value pay_payroll_actions.legislative_parameters%type;
1626:
1627: begin
1628:

Line 1625: par_value pay_payroll_actions.legislative_parameters%type;

1621:
1622: start_ptr number;
1623: end_ptr number;
1624: token_val pay_payroll_actions.legislative_parameters%type;
1625: par_value pay_payroll_actions.legislative_parameters%type;
1626:
1627: begin
1628:
1629: token_val := name || '=';