APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 138: from pay_payroll_actions

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

Line 206: from pay_payroll_actions ppa2

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

Line 326: , pay_payroll_actions ppa

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

Line 337: from pay_payroll_actions

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

Line 384: update pay_payroll_actions

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

Line 391: from pay_payroll_actions

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

Line 396: from pay_payroll_actions

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

Line 401: from pay_payroll_actions

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

Line 406: from pay_payroll_actions

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

Line 411: from pay_payroll_actions

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

Line 487: pay_payroll_actions ppa

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

Line 537: pay_payroll_actions ppa

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

Line 591: pay_payroll_actions ppa_arch,

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

Line 655: ,pay_payroll_actions ppa_arch

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

Line 710: leg_param pay_payroll_actions.legislative_parameters%type;

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

Line 736: from pay_payroll_actions

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

Line 741: from pay_payroll_actions

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

Line 746: from pay_payroll_actions

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

Line 751: from pay_payroll_actions

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

Line 756: from pay_payroll_actions

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

Line 1124: from pay_payroll_actions ppa,

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

Line 1626: token_val pay_payroll_actions.legislative_parameters%type;

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

Line 1627: par_value pay_payroll_actions.legislative_parameters%type;

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