eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_PAYROLL_ACTIONS

Line 332: pay_payroll_actions ppa

328: CURSOR c_chk_archive IS
329: SELECT 'Y' found_flag
330: FROM pay_action_information pai,
331: pay_assignment_actions act,
332: pay_payroll_actions ppa
333: WHERE ppa.report_type = 'P46_CAR_EDI'
334: AND ppa.report_qualifier='GB'
335: AND ppa.report_category ='EDI'
336: AND ppa.action_type = 'X'

Line 386: pay_payroll_actions ppa

382: CURSOR c_chk_archive IS
383: SELECT 'Y' found_flag
384: FROM pay_action_information pai,
385: pay_assignment_actions act,
386: pay_payroll_actions ppa
387: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI','P46_CAR_EDI_V3','P46_CAR_EDI_V4','P46_CAR_EDI_V5') --Bug 10095492: Added V4 --Bug 13400872: Added V5
388: AND ppa.report_qualifier='GB'
389: AND ppa.report_category ='EDI'
390: AND ppa.action_type = 'X'

Line 439: pay_payroll_actions ppa,

435: substr(org.org_information2 ,1,40) tax_district_name,
436: organization_id,
437: ppa.effective_date
438: FROM
439: pay_payroll_actions ppa,
440: hr_organization_information org
441: WHERE ppa.payroll_action_id = pactid
442: AND org.org_information_context = 'Tax Details References'
443: AND NVL(org.org_information10,'UK') = 'UK'

Line 502: 'pay_payroll_actions ppa '||

498: hr_utility.set_location(l_proc, 30);
499: --
500: sqlstr := 'select distinct person_id '||
501: 'from per_people_f ppf, '||
502: 'pay_payroll_actions ppa '||
503: 'where ppa.payroll_action_id = :payroll_action_id '||
504: 'and ppa.business_group_id = ppf.business_group_id '||
505: 'order by ppf.person_id';
506:

Line 536: pay_payroll_actions ppa,

532: substr(org.org_information2 ,1,40) tax_district_name,
533: organization_id,
534: ppa.effective_date
535: FROM
536: pay_payroll_actions ppa,
537: hr_organization_information org
538: WHERE ppa.payroll_action_id = pactid
539: AND org.org_information_context = 'Tax Details References'
540: AND NVL(org.org_information10,'UK') = 'UK'

Line 598: 'pay_payroll_actions ppa '||

594: hr_utility.set_location(l_proc, 30);
595: --
596: sqlstr := 'select distinct person_id '||
597: 'from per_people_f ppf, '||
598: 'pay_payroll_actions ppa '||
599: 'where ppa.payroll_action_id = :payroll_action_id '||
600: 'and ppa.business_group_id = ppf.business_group_id '||
601: 'order by ppf.person_id';
602:

Line 633: pay_payroll_actions ppa,

629: substr(org.org_information2 ,1,40) tax_district_name,
630: organization_id,
631: ppa.effective_date
632: FROM
633: pay_payroll_actions ppa,
634: hr_organization_information org
635: WHERE ppa.payroll_action_id = pactid
636: AND org.org_information_context = 'Tax Details References'
637: AND NVL(org.org_information10,'UK') = 'UK'

Line 695: 'pay_payroll_actions ppa '||

691: hr_utility.set_location(l_proc, 30);
692: --
693: sqlstr := 'select distinct person_id '||
694: 'from per_people_f ppf, '||
695: 'pay_payroll_actions ppa '||
696: 'where ppa.payroll_action_id = :payroll_action_id '||
697: 'and ppa.business_group_id = ppf.business_group_id '||
698: 'order by ppf.person_id';
699:

Line 729: pay_payroll_actions ppa,

725: substr(org.org_information2 ,1,40) tax_district_name,
726: organization_id,
727: ppa.effective_date
728: FROM
729: pay_payroll_actions ppa,
730: hr_organization_information org
731: WHERE ppa.payroll_action_id = pactid
732: AND org.org_information_context = 'Tax Details References'
733: AND NVL(org.org_information10,'UK') = 'UK'

Line 791: 'pay_payroll_actions ppa '||

787: hr_utility.set_location(l_proc, 30);
788: --
789: sqlstr := 'select distinct person_id '||
790: 'from per_people_f ppf, '||
791: 'pay_payroll_actions ppa '||
792: 'where ppa.payroll_action_id = :payroll_action_id '||
793: 'and ppa.business_group_id = ppf.business_group_id '||
794: 'order by ppf.person_id';
795:

Line 839: FROM pay_payroll_actions

835: pay_gb_eoy_archive.get_parameter(
836: legislative_parameters,
837: 'END_DATE')) end_date,
838: business_group_id
839: FROM pay_payroll_actions
840: WHERE payroll_action_id = pactid;
841: --
842: CURSOR c_asg IS
843: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

Line 1304: FROM pay_payroll_actions

1300: pay_gb_eoy_archive.get_parameter(
1301: legislative_parameters,
1302: 'END_DATE')) end_date,
1303: business_group_id
1304: FROM pay_payroll_actions
1305: WHERE payroll_action_id = pactid;
1306: --
1307: CURSOR c_asg IS
1308: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

Line 1838: FROM pay_payroll_actions

1834: pay_gb_eoy_archive.get_parameter(
1835: legislative_parameters,
1836: 'END_DATE')) end_date,
1837: business_group_id
1838: FROM pay_payroll_actions
1839: WHERE payroll_action_id = pactid;
1840: --
1841: CURSOR c_asg IS
1842: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

Line 2378: FROM pay_payroll_actions

2374: pay_gb_eoy_archive.get_parameter(
2375: legislative_parameters,
2376: 'END_DATE')) end_date,
2377: business_group_id
2378: FROM pay_payroll_actions
2379: WHERE payroll_action_id = pactid;
2380: --
2381: CURSOR c_asg IS
2382: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)