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_EYU dependencies on PAY_ASSIGNMENT_ACTIONS

Line 450: FROM pay_assignment_actions act,

446: SUBSTR(pap.sex,1,1) sex ,
447: DECODE(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
448: DECODE(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
449: pap.business_group_id business_group_id
450: FROM pay_assignment_actions act,
451: per_all_assignments_f paa,
452: per_all_people_f pap
453: WHERE act.assignment_action_id = p_assactid
454: AND act.assignment_id = paa.assignment_id

Line 952: FROM pay_assignment_actions

948:
949: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
950: IS
951: SELECT MAX(ASSIGNMENT_ACTION_ID)
952: FROM pay_assignment_actions
953: WHERE SOURCE_ACTION_ID = c_lst_act_id;
954:
955: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
956: select pdb.defined_balance_id from

Line 1300: FROM pay_assignment_actions

1296:
1297: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1298: IS
1299: SELECT MAX(ASSIGNMENT_ACTION_ID)
1300: FROM pay_assignment_actions
1301: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1302:
1303: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
1304: select pdb.defined_balance_id from pay_defined_balances pdb,

Line 1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1349: is
1350: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
1351:
1352: cursor csr_reversal is
1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1354: where paa.assignment_action_id = p_last_asg_action_id
1355: and paa.payroll_action_id = ppa.payroll_action_id
1356: and ACTION_TYPE in ('V');
1357:

Line 2059: from pay_assignment_actions paa , pay_action_information pai

2055: (ACTION_INFORMATION20),
2056: (ACTION_INFORMATION21),
2057: (ACTION_INFORMATION22)
2058:
2059: from pay_assignment_actions paa , pay_action_information pai
2060: where paa.payroll_action_id = pactid
2061: and paa.ASSIGNMENT_ID = p_asg_id
2062: and pai.action_context_id = paa.assignment_action_id
2063: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2076: from pay_assignment_actions paa , pay_action_information pai

2072: (ACTION_INFORMATION19),
2073: (ACTION_INFORMATION20),
2074: (ACTION_INFORMATION21),
2075: (ACTION_INFORMATION22)
2076: from pay_assignment_actions paa , pay_action_information pai
2077: where paa.payroll_action_id = pactid
2078: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_archive_tab(0).person_id)
2079: and pai.action_context_id = paa.assignment_action_id
2080: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2096: from pay_assignment_actions paa , pay_action_information pai

2092: (ACTION_INFORMATION19),
2093: (ACTION_INFORMATION20),
2094: (ACTION_INFORMATION21),
2095: (ACTION_INFORMATION22)
2096: from pay_assignment_actions paa , pay_action_information pai
2097: where paa.payroll_action_id = pactid
2098: and paa.ASSIGNMENT_ID = p_asg_id
2099: and pai.action_context_id = paa.assignment_action_id
2100: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_EYU_ASG_DET'

Line 2236: from pay_assignment_actions paa , pay_action_information pai

2232: (ACTION_INFORMATION5) l_uap,
2233: (ACTION_INFORMATION6) l_uel,
2234: (ACTION_INFORMATION7) l_emr,
2235: (ACTION_INFORMATION8) l_emp
2236: from pay_assignment_actions paa , pay_action_information pai
2237: where paa.payroll_action_id = pactid
2238: and paa.ASSIGNMENT_ID = p_asg_id
2239: and pai.action_context_id = paa.assignment_action_id
2240: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_NI_DET'

Line 2319: from pay_assignment_actions paa , pay_action_information pai

2315:
2316: cursor csr_get_latest_fps_asg is
2317: select
2318: pai.assignment_id
2319: from pay_assignment_actions paa , pay_action_information pai
2320: where paa.payroll_action_id = pactid
2321: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_person_id)
2322: and pai.action_context_id = paa.assignment_action_id
2323: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_ASG_DET2'

Line 2337: from pay_assignment_actions paa , pay_action_information pai

2333: (ACTION_INFORMATION5) l_uap,
2334: (ACTION_INFORMATION6) l_uel,
2335: (ACTION_INFORMATION7) l_emr,
2336: (ACTION_INFORMATION8) l_emp
2337: from pay_assignment_actions paa , pay_action_information pai
2338: where paa.payroll_action_id = pactid
2339: and paa.ASSIGNMENT_ID = l_latest_fps_asg
2340: and pai.action_context_id = paa.assignment_action_id
2341: and pai.ACTION_INFORMATION_CATEGORY = 'GB_RTI_FPS_NI_DET'

Line 2916: FROM pay_payroll_actions ppa, pay_assignment_actions paa

2912:
2913: -- To fetch Effective date
2914: CURSOR get_effective_date IS
2915: SELECT ppa.effective_date
2916: FROM pay_payroll_actions ppa, pay_assignment_actions paa
2917: WHERE ppa.payroll_action_id = paa.payroll_action_id
2918: AND paa.assignment_action_id = p_assactid;
2919:
2920: --Declarations

Line 3572: ,pay_assignment_actions paa

3568: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3569: /*ppa.effective_date*/
3570: sysdate
3571: from pay_payroll_actions ppa
3572: ,pay_assignment_actions paa
3573: where paa.assignment_action_id = c_assignment_action_id
3574: and ppa.payroll_action_id = paa.payroll_action_id;
3575:
3576: l_date_valid DATE;

Line 3885: from pay_assignment_actions paa,

3881: AND aei_information_category = 'GB_RTI_AGGREGATION';
3882:
3883: --Cursor to fetch Latest FPS Run date for the assignment
3884: cursor csr_latest_fps_date(asg_id number) is select ppa.effective_date,ppa.payroll_action_id
3885: from pay_assignment_actions paa,
3886: pay_payroll_actions ppa
3887: where paa.assignment_id = asg_id
3888: and paa.action_status ='C'
3889: and ppa.action_type ='X'

Line 3897: select paa.ASSIGNMENT_ACTION_ID , ppa.EFFECTIVE_DATE from pay_payroll_actions ppa,pay_assignment_actions paa

3893: and UPPER(l_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))
3894: order by ppa.effective_date desc;
3895:
3896: CURSOR csr_latest_asg_action1(asg_id number,p_pact_id number) is
3897: select paa.ASSIGNMENT_ACTION_ID , ppa.EFFECTIVE_DATE from pay_payroll_actions ppa,pay_assignment_actions paa
3898: where ASSIGNMENT_ID = asg_id
3899: and ppa.ACTION_TYPE in ('Q','R','B','I','V','P','U')
3900: AND paa.action_status IN ('C', 'S')
3901: and ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID

Line 3913: FROM pay_assignment_actions paa

3909: to_number (substr (max (lpad (paa.action_sequence, 15
3910: , '0')
3911: || paa.assignment_action_id), 16))
3912: , max (pact.effective_date) effective_date
3913: FROM pay_assignment_actions paa
3914: , pay_payroll_actions pact
3915: , per_time_periods ptp
3916: WHERE paa.assignment_id = asg_id
3917: AND paa.payroll_action_id = pact.payroll_action_id

Line 3929: FROM pay_payroll_actions pact, pay_assignment_actions paa

3925:
3926: cursor csr_action_type (l_asg_act_id number) is
3927: SELECT
3928: pact.action_type
3929: FROM pay_payroll_actions pact, pay_assignment_actions paa
3930: WHERE paa.ASSIGNMENT_ACTION_ID = l_asg_act_id
3931: and paa.payroll_action_id = pact.payroll_action_id;
3932:
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is

Line 3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,

3930: WHERE paa.ASSIGNMENT_ACTION_ID = l_asg_act_id
3931: and paa.payroll_action_id = pact.payroll_action_id;
3932:
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is
3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,
3935: per_all_assignments_f paaf,
3936: pay_all_payrolls_f pay,
3937: hr_soft_coding_keyflex sck
3938: where paa.ASSIGNMENT_ID = asg_id

Line 3960: FROM pay_assignment_actions paa

3956:
3957:
3958: cursor csr_all_actions_tax_year (asg_id number)is
3959: select paa.assignment_action_id asg_act_id
3960: FROM pay_assignment_actions paa
3961: , pay_payroll_actions pact
3962: , per_time_periods ptp,
3963: per_all_assignments_f paaf,
3964: pay_all_payrolls_f pay,

Line 3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,

3987: AND g_end_year;
3988:
3989:
3990: cursor csr_all_actions_after_fps_agg (per_id number, p_pact_id number) is
3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,
3992: pay_all_payrolls_f pay,
3993: hr_soft_coding_keyflex sck
3994: where paaf.person_ID = per_id
3995: and paa.assignment_id = paaf.assignment_id

Line 4017: pay_assignment_actions paa

4013:
4014: cursor csr_all_actions_tax_year_agg (per_id number)is
4015: select paa.ASSIGNMENT_ACTION_ID asg_act_id
4016: FROM per_all_assignments_f paaf,
4017: pay_assignment_actions paa
4018: , pay_payroll_actions pact
4019: , per_time_periods ptp,
4020: pay_all_payrolls_f pay,
4021: hr_soft_coding_keyflex sck

Line 4054: pay_assignment_actions paa

4050: || paa.assignment_action_id), 16))
4051: , max (pact.effective_date) effective_date
4052:
4053: FROM per_all_assignments_f paaf,
4054: pay_assignment_actions paa
4055: , pay_payroll_actions pact
4056: , per_time_periods ptp,
4057: pay_all_payrolls_f pay,
4058: hr_soft_coding_keyflex sck

Line 4091: pay_assignment_actions paa

4087: || paa.assignment_action_id), 16))
4088: , max (pact.effective_date) effective_date
4089:
4090: FROM per_all_assignments_f paaf,
4091: pay_assignment_actions paa
4092: , pay_payroll_actions pact
4093: , per_time_periods ptp,
4094: pay_all_payrolls_f pay,
4095: hr_soft_coding_keyflex sck

Line 4120: select assignment_id from pay_assignment_actions where assignment_action_id = p_asg_act_id;

4116: and asg2.effective_start_date <= g_end_year
4117: );
4118:
4119: cursor csr_latest_asg(p_asg_act_id number) is
4120: select assignment_id from pay_assignment_actions where assignment_action_id = p_asg_act_id;
4121:
4122: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
4123: cursor csr_ni_rpt_flag(c_asg_id number) is
4124: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id

Line 4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

4269:
4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:
4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4274: -- Insert assignment into pay_assignment_actions
4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
4276:
4277: --Locking mechanism

Line 4274: -- Insert assignment into pay_assignment_actions

4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:
4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4274: -- Insert assignment into pay_assignment_actions
4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
4276:
4277: --Locking mechanism
4278: -- If NI Aggr and non aggr

Line 4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

4406:
4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:
4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
4413:
4414: --NI Aggr

Line 4411: -- Insert assignment into pay_assignment_actions

4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:
4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
4413:
4414: --NI Aggr
4415: hr_utility.set_location('Action Created for RTI Reporting Ni Aggr asg : '||l_ni_rpt_asg_id,20);

Line 4495: FROM pay_assignment_actions paa,

4491: IS
4492: SELECT aei.assignment_extra_info_id,
4493: aei.object_version_number,
4494: aei.aei_information8
4495: FROM pay_assignment_actions paa,
4496: per_assignment_extra_info aei
4497: WHERE paa.assignment_action_id = p_assact
4498: AND aei.assignment_id = paa.assignment_id
4499: AND aei.information_type = p_type;

Line 4506: FROM pay_assignment_actions paa,

4502: IS
4503: SELECT aei.assignment_extra_info_id,
4504: aei.object_version_number,
4505: aei.aei_information9
4506: FROM pay_assignment_actions paa,
4507: per_assignment_extra_info aei
4508: WHERE paa.assignment_action_id = p_assact
4509: AND aei.assignment_id = paa.assignment_id
4510: AND aei.information_type = p_type;

Line 4517: FROM pay_assignment_actions paa,

4513: IS
4514: SELECT aei.assignment_extra_info_id,
4515: aei.object_version_number,
4516: aei.aei_information19
4517: FROM pay_assignment_actions paa,
4518: per_assignment_extra_info aei
4519: WHERE paa.assignment_action_id = p_assact
4520: AND aei.assignment_id = paa.assignment_id
4521: AND aei.information_type = p_type;

Line 5351: from pay_assignment_actions paa,

5347: paaf.person_id ,
5348: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
5349: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
5350: assignment_number
5351: from pay_assignment_actions paa,
5352: per_all_assignments_f paaf,
5353: per_all_people_f pap
5354: where assignment_action_id = p_assactid
5355: and paaf.assignment_id = paa.assignment_id

Line 5374: FROM pay_assignment_actions paa

5370: to_number (substr (max (lpad (paa.action_sequence, 15
5371: , '0')
5372: || paa.assignment_action_id), 16))
5373: , max (pact.effective_date) effective_date
5374: FROM pay_assignment_actions paa
5375: , pay_payroll_actions pact
5376: , per_time_periods ptp
5377: WHERE paa.assignment_id = asg_id
5378: AND paa.payroll_action_id = pact.payroll_action_id

Line 5397: pay_assignment_actions paa

5393: || paa.assignment_action_id), 16))
5394: , max (pact.effective_date) effective_date
5395:
5396: FROM per_all_assignments_f paaf,
5397: pay_assignment_actions paa
5398: , pay_payroll_actions pact
5399: , per_time_periods ptp,
5400: pay_all_payrolls_f pay,
5401: hr_soft_coding_keyflex sck

Line 5426: from pay_assignment_actions paa,

5422:
5423: --Cursor to fetch Latest FPS Run date and Payroll action ID for the assignment
5424: cursor csr_latest_fps(asg_id number) is
5425: select ppa.effective_date,ppa.payroll_action_id,ppa.report_type
5426: from pay_assignment_actions paa,
5427: pay_payroll_actions ppa
5428: where paa.assignment_id = asg_id
5429: and paa.action_status ='C'
5430: and ppa.payroll_action_id = paa.payroll_action_id

Line 5438: from pay_assignment_actions paa,

5434:
5435: --cursor to get person latest fps run
5436: cursor csr_latest_fps_payeagg(per_id number) is
5437: select ppa.effective_date,ppa.payroll_action_id,ppa.report_type
5438: from pay_assignment_actions paa,
5439: pay_payroll_actions ppa,
5440: per_all_assignments_f paaf ,
5441: pay_all_payrolls_f pay,
5442: hr_soft_coding_keyflex sck

Line 5463: pay_assignment_actions

5459: order by ppa.effective_date desc;
5460:
5461: cursor csr_is_retry_request is
5462: select 'Y' from
5463: pay_assignment_actions
5464: where assignment_action_id = p_assactid
5465: AND ACTION_STATUS = 'M';
5466:
5467: CURSOR csr_get_starter_details(p_asg_id NUMBER)

Line 5480: from pay_assignment_actions paa,

5476: AND information_type = 'GB_RTI_ASG_DETAILS';
5477:
5478: cursor csr_fps_check(p_asg_id number) is
5479: select count(*)
5480: from pay_assignment_actions paa,
5481: pay_payroll_actions ppa
5482: where paa.assignment_id = p_asg_id
5483: and paa.action_status ='C'
5484: and paa.assignment_action_id <> p_assactid

Line 5832: pay_assignment_actions paa

5828: IS
5829: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5830: assignment_id
5831: FROM pay_payroll_actions ppa,
5832: pay_assignment_actions paa
5833: WHERE ppa.payroll_action_id = pactid -- pact_id
5834: AND paa.payroll_action_id = ppa.payroll_action_id
5835: AND paa.action_status = 'E';
5836:

Line 5977: pay_assignment_actions paa

5973: IS
5974: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5975: assignment_id
5976: FROM pay_payroll_actions ppa,
5977: pay_assignment_actions paa
5978: WHERE ppa.payroll_action_id = pactid -- pact_id
5979: AND paa.payroll_action_id = ppa.payroll_action_id
5980: AND paa.action_status = 'C';
5981:

Line 5988: pay_assignment_actions paa

5984: IS
5985: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5986: assignment_id
5987: FROM pay_payroll_actions ppa,
5988: pay_assignment_actions paa
5989: WHERE ppa.payroll_action_id = pactid -- pact_id
5990: AND paa.payroll_action_id = ppa.payroll_action_id
5991: AND paa.action_status = 'E';
5992:

Line 6122: pay_assignment_actions paa,

6118: CURSOR get_person_count
6119: IS
6120: SELECT COUNT(DISTINCT(paaf.person_id))
6121: FROM pay_payroll_actions ppa,
6122: pay_assignment_actions paa,
6123: per_all_assignments_f paaf
6124: WHERE ppa.payroll_action_id = pactid -- pact_id
6125: AND paa.payroll_action_id = ppa.payroll_action_id
6126: AND paa.action_status = 'C'