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

Line 902: from pay_payroll_actions pact,

898: cursor csr_parameter_info is
899: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
900: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
901: business_group_id
902: from pay_payroll_actions pact,
903: pay_assignment_actions paa
904: where paa.assignment_action_id = p_assactid
905: and pact.payroll_action_id = paa.payroll_action_id;
906:

Line 1155: FROM pay_payroll_actions ppa, pay_assignment_actions paa

1151: edi_validation_fail out nocopy varchar2) IS
1152:
1153: CURSOR get_effective_date IS
1154: SELECT ppa.effective_date
1155: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1156: WHERE ppa.payroll_action_id = paa.payroll_action_id
1157: AND paa.assignment_action_id = p_assactid;
1158:
1159: l_proc CONSTANT VARCHAR2(50):= g_package||'eas_asg_etext_validations';

Line 2094: from pay_payroll_actions prev

2090: return varchar2 is
2091: l_exists varchar2(1):='N';
2092: cursor get_prev_flag is
2093: select 'Y' from dual where exists(select *
2094: from pay_payroll_actions prev
2095: where prev.payroll_action_id <> pactid
2096: and prev.business_group_id =bg_id
2097: and prev.ACTION_STATUS='C'
2098: and prev.REPORT_TYPE='RTI_EAS_REP_13'

Line 2153: from pay_payroll_actions pact,

2149: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'NO_OF_PARTS'),1,2) no_of_parts,
2150: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,
2151: report_type,
2152: business_group_id
2153: from pay_payroll_actions pact,
2154: hr_organization_information hoi
2155: where pact.payroll_action_id=pactid
2156: and pact.business_group_id = hoi.organization_id
2157: and hoi.org_information_context = 'Tax Details References'

Line 2165: from pay_payroll_actions pact

2161: instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1;
2162:
2163: cursor csr_get_paye_ref(pactid number) is
2164: select pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF')
2165: from pay_payroll_actions pact
2166: where payroll_action_id = pactid;
2167:
2168: l_payroll_rec csr_payroll_details%rowtype;
2169: BEGIN

Line 2238: 'pay_payroll_actions ppa '||

2234: IF l_report_type = 'RTI_EAS_REP_13' THEN
2235:
2236: sqlstr := 'select distinct person_id '||
2237: 'from per_all_people_f ppf, '||
2238: 'pay_payroll_actions ppa '||
2239: 'where ppa.payroll_action_id = :payroll_action_id '||
2240: 'and ppa.business_group_id = ppf.business_group_id '||
2241: 'order by ppf.person_id';
2242: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 2274: 'pay_payroll_actions ppa '||

2270:
2271: IF (l_payroll_id is null) THEN
2272: sqlstr := 'select distinct person_id '||
2273: 'from per_all_people_f ppf, '||
2274: 'pay_payroll_actions ppa '||
2275: 'where ppa.payroll_action_id = :payroll_action_id '||
2276: 'and ppa.business_group_id = ppf.business_group_id '||
2277: 'order by ppf.person_id';
2278:

Line 2286: 'pay_payroll_actions ppa '||

2282:
2283: IF ((l_employee_number is null) and (l_assignment_set is null)) THEN
2284: sqlstr := 'select distinct PERSON_ID '||
2285: 'from per_all_assignments_f paaf, '||
2286: 'pay_payroll_actions ppa '||
2287: 'where ppa.payroll_action_id = :payroll_action_id '||
2288: 'and ppa.business_group_id = paaf.business_group_id '||
2289: ' and paaf.PAYROLL_ID = ' ||''''||l_payroll_id||''''||
2290: ' order by person_id';

Line 2297: 'pay_payroll_actions ppa '||

2293: IF (l_employee_number is not null ) THEN
2294: sqlstr := 'select distinct ppf.person_id '||
2295: 'from per_all_people_f ppf, '||
2296: 'per_all_assignments_f paaf, '||
2297: 'pay_payroll_actions ppa '||
2298: 'where ppa.payroll_action_id = :payroll_action_id '||
2299: ' and paaf.person_id=ppf.person_id '||
2300: 'and ppa.business_group_id = ppf.business_group_id '||
2301: ' and ppf.EMPLOYEE_NUMBER = ' ||''''||l_employee_number||''''||

Line 2310: 'pay_payroll_actions ppa '||

2306: IF (l_assignment_set is not null)THEN
2307:
2308: sqlstr := 'select distinct person_id '||
2309: 'from per_all_people_f ppf, '||
2310: 'pay_payroll_actions ppa '||
2311: 'where ppa.payroll_action_id = :payroll_action_id '||
2312: 'and ppa.business_group_id = ppf.business_group_id '||
2313: 'order by ppf.person_id';
2314: END IF;

Line 2382: from pay_payroll_actions pact

2378: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
2379: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'NO_OF_PARTS'),1,2) no_of_parts,
2380: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PERMIT'),1,12) unique_part_id,
2381: business_group_id
2382: from pay_payroll_actions pact
2383: where payroll_action_id = pactid;
2384:
2385: -- Cursor to fetch Active Assignments
2386: cursor csr_asg_active is

Line 2707: from pay_payroll_actions

2703: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
2704: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,
2705: effective_date,
2706: business_group_id
2707: from pay_payroll_actions
2708: where payroll_action_id = pactid;
2709:
2710: cursor csr_asg is
2711: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,

Line 2876: from pay_payroll_actions pact,

2872: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'NO_OF_PARTS'),1,2) no_of_parts,
2873: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,
2874: report_type,
2875: business_group_id
2876: from pay_payroll_actions pact,
2877: hr_organization_information hoi
2878: where pact.payroll_action_id=pactid
2879: and pact.business_group_id = hoi.organization_id
2880: and hoi.org_information_context = 'Tax Details References'

Line 2888: from pay_payroll_actions pact

2884: instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1;
2885:
2886: cursor csr_get_paye_ref(pactid number) is
2887: select pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF')
2888: from pay_payroll_actions pact
2889: where payroll_action_id = pactid;
2890:
2891:
2892: l_payroll_rec csr_payroll_details%rowtype;

Line 3033: pay_payroll_actions ppa

3029: cursor csr_archive_type is
3030: select report_type,paa.payroll_action_id,BUSINESS_GROUP_ID,
3031: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
3032: from pay_assignment_actions paa,
3033: pay_payroll_actions ppa
3034: where paa.assignment_action_id = p_assactid
3035: and paa.payroll_action_id = ppa.payroll_action_id;
3036:
3037: cursor get_already_processed_asg(p_pact_id number,p_person_id number,p_business_group_id number,p_effective_date date)

Line 3060: from pay_payroll_actions ppa,

3056:
3057: cursor processed_asg(p_business_group_id number,p_assignment_id number,p_tax_ref varchar2,p_effective_date date)
3058: is
3059: select distinct ppa.payroll_action_id
3060: from pay_payroll_actions ppa,
3061: pay_assignment_actions paa,
3062: per_all_assignments_f asg1,
3063: per_all_assignments_f asg2
3064: where asg1.assignment_id = p_assignment_id

Line 3330: From pay_payroll_actions pact

3326: l_counter number;
3327:
3328: Cursor csr_is_etext_report IS
3329: Select report_type
3330: From pay_payroll_actions pact
3331: Where pact.payroll_action_id = pactid;
3332:
3333: l_is_etext_report varchar2(50);
3334: l_request_id fnd_concurrent_requests.request_id%TYPE;

Line 3360: from pay_payroll_actions pact,

3356: as acc_ref_no,
3357:
3358: pact.business_group_id bus_grp_id,
3359: pact.action_parameter_group_id act_param_grp_id
3360: from pay_payroll_actions pact,
3361: hr_organization_information hoi
3362: where pact.payroll_action_id=pactid
3363: and pact.business_group_id = hoi.organization_id
3364: and hoi.org_information_context = 'Tax Details References'

Line 3397: from pay_payroll_actions pact

3393: select legislative_parameters para,
3394: fnd_number.number_to_canonical(request_id) control_id,
3395: report_type,
3396: business_group_id
3397: from pay_payroll_actions pact
3398: where payroll_action_id = pactid;
3399:
3400: cursor csr_date is
3401: 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 3402: from pay_payroll_actions pact

3398: where payroll_action_id = pactid;
3399:
3400: cursor csr_date is
3401: select to_char(to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD'),'DD-MON-RRRR') effective_date
3402: from pay_payroll_actions pact
3403: where payroll_action_id = pactid;
3404:
3405:
3406: cursor csr_header_det(p_bus_id number,

Line 3619: from pay_payroll_actions pact,

3615:
3616: cursor csr_payroll_details(pactid NUMBER) is
3617: select
3618: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date
3619: from pay_payroll_actions pact,
3620: hr_organization_information hoi
3621: where pact.payroll_action_id=pactid
3622: and pact.business_group_id = hoi.organization_id
3623: and hoi.org_information_context = 'Tax Details References'

Line 3633: from pay_payroll_actions ppa,

3629: -- Cursor to fetch Completed records
3630: cursor get_asg_action_id is
3631: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3632: , paaf.assignment_number
3633: from pay_payroll_actions ppa,
3634: pay_assignment_actions paa
3635: , per_all_assignments_f paaf
3636: where ppa.payroll_action_id = pactid -- pact_id
3637: and paa.payroll_action_id = ppa.payroll_action_id

Line 3652: from pay_payroll_actions ppa,

3648: -- Cursor to fetch Errored Records
3649: cursor get_asg_action_id_error is
3650: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3651: , paaf.assignment_number
3652: from pay_payroll_actions ppa,
3653: pay_assignment_actions paa
3654: , per_all_assignments_f paaf
3655: where ppa.payroll_action_id = pactid -- pact_id
3656: and paa.payroll_action_id = ppa.payroll_action_id

Line 3671: from pay_payroll_actions

3667:
3668: --Cursor to get effective date for NINO
3669: cursor csr_parameter_date is
3670: select effective_date
3671: from pay_payroll_actions
3672: where payroll_action_id = pactid;
3673:
3674:
3675: cursor get_person_details_archive(c_assignment_id number) is

Line 3711: ,pay_payroll_actions ppa

3707: pap.person_id
3708: from per_all_assignments_f paa,
3709: per_assignment_status_types past,
3710: per_all_people_f pap
3711: ,pay_payroll_actions ppa
3712: where paa.person_id = pap.person_id
3713: and paa.assignment_id = c_assignment_id
3714: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
3715: -- and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488

Line 3962: from pay_payroll_actions ppa,

3958: procedure write_footer is
3959:
3960: cursor get_person_count is
3961: select count(distinct(paaf.person_id))
3962: from pay_payroll_actions ppa,
3963: pay_assignment_actions paa,
3964: per_all_assignments_f paaf
3965: where ppa.payroll_action_id = pactid -- pact_id
3966: and paa.payroll_action_id = ppa.payroll_action_id

Line 4141: from pay_payroll_actions ppa

4137:
4138: cursor csr_parameter_info is
4139: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
4140: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
4141: from pay_payroll_actions ppa
4142: ,pay_assignment_actions paa
4143: where paa.assignment_action_id = c_assignment_action_id
4144: and ppa.payroll_action_id = paa.payroll_action_id;
4145: