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_RTI dependencies on PAY_PAYROLL_ACTIONS

Line 516: from pay_payroll_actions pact,

512:
513: cursor csr_parameter_info is
514: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
515: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date
516: from pay_payroll_actions pact,
517: pay_assignment_actions paa
518: where paa.assignment_action_id = p_assactid
519: and pact.payroll_action_id = paa.payroll_action_id;
520:

Line 742: FROM pay_payroll_actions ppa, pay_assignment_actions paa

738: edi_validation_fail out nocopy varchar2) IS
739:
740: CURSOR get_effective_date IS
741: SELECT ppa.effective_date
742: FROM pay_payroll_actions ppa, pay_assignment_actions paa
743: WHERE ppa.payroll_action_id = paa.payroll_action_id
744: AND paa.assignment_action_id = p_assactid;
745:
746: l_proc CONSTANT VARCHAR2(50):= g_package||'eas_asg_etext_validations';

Line 1610: FROM pay_payroll_actions

1606: IS
1607:
1608: cursor csr_parameter_info IS
1609: SELECT report_type
1610: FROM pay_payroll_actions
1611: WHERE payroll_action_id = pactid;
1612:
1613: l_report_type varchar2(15);
1614: --NINO New CP addition

Line 1634: 'pay_payroll_actions ppa '||

1630: IF l_report_type = 'RTI_EAS_REP' THEN
1631:
1632: sqlstr := 'select distinct person_id '||
1633: 'from per_all_people_f ppf, '||
1634: 'pay_payroll_actions ppa '||
1635: 'where ppa.payroll_action_id = :payroll_action_id '||
1636: 'and ppa.business_group_id = ppf.business_group_id '||
1637: 'order by ppf.person_id';
1638: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 1670: 'pay_payroll_actions ppa '||

1666:
1667: IF (l_payroll_id is null) THEN
1668: sqlstr := 'select distinct person_id '||
1669: 'from per_all_people_f ppf, '||
1670: 'pay_payroll_actions ppa '||
1671: 'where ppa.payroll_action_id = :payroll_action_id '||
1672: 'and ppa.business_group_id = ppf.business_group_id '||
1673: 'order by ppf.person_id';
1674:

Line 1682: 'pay_payroll_actions ppa '||

1678:
1679: IF ((l_employee_number is null) and (l_assignment_set is null)) THEN
1680: sqlstr := 'select distinct PERSON_ID '||
1681: 'from per_all_assignments_f paaf, '||
1682: 'pay_payroll_actions ppa '||
1683: 'where ppa.payroll_action_id = :payroll_action_id '||
1684: 'and ppa.business_group_id = paaf.business_group_id '||
1685: ' and paaf.PAYROLL_ID = ' ||''''||l_payroll_id||''''||
1686: ' order by person_id';

Line 1693: 'pay_payroll_actions ppa '||

1689: IF (l_employee_number is not null ) THEN
1690: sqlstr := 'select distinct ppf.person_id '||
1691: 'from per_all_people_f ppf, '||
1692: 'per_all_assignments_f paaf, '||
1693: 'pay_payroll_actions ppa '||
1694: 'where ppa.payroll_action_id = :payroll_action_id '||
1695: ' and paaf.person_id=ppf.person_id '||
1696: 'and ppa.business_group_id = ppf.business_group_id '||
1697: ' and ppf.EMPLOYEE_NUMBER = ' ||''''||l_employee_number||''''||

Line 1706: 'pay_payroll_actions ppa '||

1702: IF (l_assignment_set is not null)THEN
1703:
1704: sqlstr := 'select distinct person_id '||
1705: 'from per_all_people_f ppf, '||
1706: 'pay_payroll_actions ppa '||
1707: 'where ppa.payroll_action_id = :payroll_action_id '||
1708: 'and ppa.business_group_id = ppf.business_group_id '||
1709: 'order by ppf.person_id';
1710: END IF;

Line 1768: from pay_payroll_actions pact

1764: cursor csr_parameter_info is
1765: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
1766: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
1767: business_group_id
1768: from pay_payroll_actions pact
1769: where payroll_action_id = pactid;
1770:
1771: -- Cursor to fetch Active Assignments
1772: cursor csr_asg_active is

Line 2057: from pay_payroll_actions

2053: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
2054: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,
2055: effective_date,
2056: business_group_id
2057: from pay_payroll_actions
2058: where payroll_action_id = pactid;
2059:
2060: cursor csr_asg is
2061: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,

Line 2234: from pay_payroll_actions pact,

2230: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
2231: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2232: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2233: report_type
2234: from pay_payroll_actions pact,
2235: hr_organization_information hoi
2236: where pact.payroll_action_id=pactid
2237: and pact.business_group_id = hoi.organization_id
2238: and hoi.org_information_context = 'Tax Details References'

Line 2362: pay_payroll_actions ppa

2358: cursor csr_archive_type is
2359: select report_type,paa.payroll_action_id,
2360: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
2361: from pay_assignment_actions paa,
2362: pay_payroll_actions ppa
2363: where paa.assignment_action_id = p_assactid
2364: and paa.payroll_action_id = ppa.payroll_action_id;
2365:
2366: -- To fetch other assignments of the PAYE Aggregation

Line 2519: From pay_payroll_actions pact

2515: l_counter number;
2516:
2517: Cursor csr_is_etext_report IS
2518: Select report_type
2519: From pay_payroll_actions pact
2520: Where pact.payroll_action_id = pactid;
2521:
2522: l_is_etext_report varchar2(50);
2523: l_request_id fnd_concurrent_requests.request_id%TYPE;

Line 2546: from pay_payroll_actions pact,

2542: as acc_ref_no,
2543:
2544: pact.business_group_id bus_grp_id,
2545: pact.action_parameter_group_id act_param_grp_id
2546: from pay_payroll_actions pact,
2547: hr_organization_information hoi
2548: where pact.payroll_action_id=pactid
2549: and pact.business_group_id = hoi.organization_id
2550: and hoi.org_information_context = 'Tax Details References'

Line 2581: from pay_payroll_actions pact

2577: select legislative_parameters para,
2578: fnd_number.number_to_canonical(request_id) control_id,
2579: report_type,
2580: business_group_id
2581: from pay_payroll_actions pact
2582: where payroll_action_id = pactid;
2583:
2584: cursor csr_date is
2585: select to_char(to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD'),'DD-MON-RRRR') effective_date

Line 2586: from pay_payroll_actions pact

2582: where payroll_action_id = pactid;
2583:
2584: cursor csr_date is
2585: select to_char(to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD'),'DD-MON-RRRR') effective_date
2586: from pay_payroll_actions pact
2587: where payroll_action_id = pactid;
2588:
2589: cursor csr_header_det(p_bus_id number,
2590: p_tax_ref varchar2) is

Line 2782: from pay_payroll_actions ppa,

2778: /*
2779: -- Cursor to fetch Completed records
2780: cursor get_asg_action_id is
2781: select distinct paa.assignment_action_id asg_action_id, assignment_id
2782: from pay_payroll_actions ppa,
2783: pay_assignment_actions paa
2784: where ppa.payroll_action_id = pactid -- pact_id
2785: and paa.payroll_action_id = ppa.payroll_action_id
2786: and paa.action_status = 'C';

Line 2790: from pay_payroll_actions ppa,

2786: and paa.action_status = 'C';
2787: -- Cursor to fetch Errored Records
2788: cursor get_asg_action_id_error is
2789: select distinct paa.assignment_action_id asg_action_id, assignment_id
2790: from pay_payroll_actions ppa,
2791: pay_assignment_actions paa
2792: where ppa.payroll_action_id = pactid -- pact_id
2793: and paa.payroll_action_id = ppa.payroll_action_id
2794: and paa.action_status = 'E';

Line 2800: from pay_payroll_actions ppa,

2796: -- Cursor to fetch Completed records
2797: cursor get_asg_action_id is
2798: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
2799: , paaf.assignment_number
2800: from pay_payroll_actions ppa,
2801: pay_assignment_actions paa
2802: , per_all_assignments_f paaf
2803: where ppa.payroll_action_id = pactid -- pact_id
2804: and paa.payroll_action_id = ppa.payroll_action_id

Line 2821: from pay_payroll_actions ppa,

2817: -- Cursor to fetch Errored Records
2818: cursor get_asg_action_id_error is
2819: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
2820: , paaf.assignment_number
2821: from pay_payroll_actions ppa,
2822: pay_assignment_actions paa
2823: , per_all_assignments_f paaf
2824: where ppa.payroll_action_id = pactid -- pact_id
2825: and paa.payroll_action_id = ppa.payroll_action_id

Line 2841: from pay_payroll_actions

2837:
2838: --Cursor to get effective date for NINO
2839: cursor csr_parameter_date is
2840: select effective_date
2841: from pay_payroll_actions
2842: where payroll_action_id = pactid;
2843:
2844:
2845: cursor get_person_details_archive(c_assignment_id number) is

Line 2902: ,pay_payroll_actions ppa

2898: pap.person_id
2899: from per_all_assignments_f paa,
2900: per_assignment_status_types past,
2901: per_all_people_f pap
2902: ,pay_payroll_actions ppa
2903: where paa.person_id = pap.person_id
2904: and paa.assignment_id = c_assignment_id
2905: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
2906: AND ppa.payroll_action_id = pactid

Line 3075: from pay_payroll_actions ppa,

3071: procedure write_footer is
3072:
3073: cursor get_person_count is
3074: select count(distinct(paaf.person_id))
3075: from pay_payroll_actions ppa,
3076: pay_assignment_actions paa,
3077: per_all_assignments_f paaf
3078: where ppa.payroll_action_id = pactid -- pact_id
3079: and paa.payroll_action_id = ppa.payroll_action_id

Line 3244: from pay_payroll_actions ppa

3240:
3241: cursor csr_parameter_info is
3242: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
3244: from pay_payroll_actions ppa
3245: ,pay_assignment_actions paa
3246: where paa.assignment_action_id = c_assignment_action_id
3247: and ppa.payroll_action_id = paa.payroll_action_id;
3248: