APPS.PAY_GB_DEO dependencies on PAY_PAYROLL_ACTIONS

Line 247: FROM pay_payroll_actions

243: IS
244:
245: cursor csr_parameter_info IS
246: SELECT report_type
247: FROM pay_payroll_actions
248: WHERE payroll_action_id = pactid;
249:
250: l_report_type varchar2(15);
251: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';

Line 265: 'pay_payroll_actions ppa '||

261: IF l_report_type = 'DEO_PAY_REP' THEN
262:
263: sqlstr := 'select distinct person_id '||
264: 'from per_all_people_f ppf, '||
265: 'pay_payroll_actions ppa '||
266: 'where ppa.payroll_action_id = :payroll_action_id '||
267: 'and ppa.business_group_id = ppf.business_group_id '||
268: 'order by ppf.person_id';
269: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 312: from pay_payroll_actions pact

308: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
309: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
310: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
311: business_group_id
312: from pay_payroll_actions pact
313: where payroll_action_id = pactid;
314:
315:
316: -- Cursor to fetch DEO screen entry values for Reference and Reason for Assignments

Line 328: pay_payroll_actions ppa

324: per_all_assignments_f paaf,
325: hr_soft_coding_keyflex sc,
326: pay_all_payrolls_f ppf,
327: pay_assignment_actions paa,
328: pay_payroll_actions ppa
329: where pet.element_name in ('Court Order','Court Order NTPP')
330: AND pet.business_group_id IS NULL
331: AND pet.legislation_code = 'GB'
332: AND pet.element_type_id = piv.element_type_id

Line 464: from pay_payroll_actions pact,

460: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
461: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
462: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
463: business_group_id
464: from pay_payroll_actions pact,
465: pay_assignment_actions paa
466: where paa.assignment_action_id = p_assactid
467: and paa.payroll_action_id = pact.payroll_action_id;
468:

Line 483: pay_payroll_actions ppa

479: per_all_assignments_f paaf,
480: hr_soft_coding_keyflex scl,
481: pay_all_payrolls_f ppf,
482: pay_assignment_actions paa,
483: pay_payroll_actions ppa
484: where pet1.element_name in ('Court Order','Court Order NTPP')
485: AND pet1.business_group_id IS NULL
486: AND pet1.legislation_code = 'GB'
487: AND pet1.element_type_id = piv1.element_type_id

Line 554: pay_payroll_actions ppa

550: per_all_assignments_f paaf,
551: hr_soft_coding_keyflex sc,
552: pay_all_payrolls_f ppf,
553: pay_assignment_actions paa,
554: pay_payroll_actions ppa
555: where pet.element_name in ('Court Order','Court Order NTPP')
556: AND pet.business_group_id IS NULL
557: AND pet.legislation_code = 'GB'
558: AND pet.element_type_id = piv.element_type_id

Line 733: From pay_payroll_actions pact

729: l_is_etext_report varchar2(50);
730:
731: Cursor csr_is_etext_report IS
732: Select report_type
733: From pay_payroll_actions pact
734: Where pact.payroll_action_id = pactid;
735:
736:
737: cursor csr_parameter_info is

Line 750: from pay_payroll_actions pact,

746: pay_gb_eoy_archive.get_parameter(legislative_parameters,'REPORT_FORMAT') report_format,
747: fnd_number.number_to_canonical(pact.request_id) request_id,
748: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
749: nvl(substr(hoi.org_information20,1,12),' ') employer_no
750: from pay_payroll_actions pact,
751: hr_organization_information hoi
752: where payroll_action_id = pactid
753: and pact.business_group_id = hoi.organization_id
754: and hoi.org_information_context = 'Tax Details References'

Line 789: from pay_payroll_actions pact

785: fnd_number.number_to_canonical(request_id) control_id,
786: report_type,
787: business_group_id,
788: pact.effective_date
789: from pay_payroll_actions pact
790: where payroll_action_id = pactid;
791:
792: cursor csr_parameter_info is
793: select

Line 799: from pay_payroll_actions pact

795: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
796: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
797: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
798: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date
799: from pay_payroll_actions pact
800: where payroll_action_id = pactid;
801:
802: cursor csr_header_det(p_bus_id number,
803: p_tax_ref varchar2) is

Line 949: from pay_payroll_actions ppa,

945: -- Cursor to fetch Completed records
946: cursor get_asg_action_id is
947: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
948: , paaf.assignment_number
949: from pay_payroll_actions ppa,
950: pay_assignment_actions paa
951: , per_all_assignments_f paaf
952: where ppa.payroll_action_id = pactid -- pact_id
953: and paa.payroll_action_id = ppa.payroll_action_id

Line 1015: from pay_payroll_actions ppa,

1011: procedure write_footer is
1012:
1013: cursor get_person_count is
1014: select count(distinct(paaf.person_id))
1015: from pay_payroll_actions ppa,
1016: pay_assignment_actions paa,
1017: per_all_assignments_f paaf
1018: where ppa.payroll_action_id = pactid -- pact_id
1019: and paa.payroll_action_id = ppa.payroll_action_id