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 PER_ALL_ASSIGNMENTS_F

Line 451: per_all_assignments_f paa,

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
455: AND paa.person_id = pap.person_id

Line 460: FROM per_all_assignments_f paa2

456: AND p_effective_date between pap.effective_start_date and pap.effective_end_date
457: AND paa.effective_start_date =
458: (
459: SELECT MAX(paa2.effective_start_date)
460: FROM per_all_assignments_f paa2
461: WHERE paa2.assignment_id = paa.assignment_id
462: AND paa2.assignment_type = 'E'
463: AND paa2.effective_start_date <= p_effective_date
464: );

Line 584: select assignment_number from per_all_assignments_f where assignment_id = p_person_rec.assignment_id

580: WHERE assignment_id = p_asg_id
581: AND information_type = 'GB_RTI_ASG_DETAILS';
582: /*
583: cursor csr_fetch_asg_num is
584: select assignment_number from per_all_assignments_f where assignment_id = p_person_rec.assignment_id
585: and p_effective_date between effective_start_date and effective_end_date;
586: */
587: --Cursor to fetch RTI Payroll ID for the assignment
588: CURSOR csr_fetch_asg_num IS

Line 598: per_all_assignments_f asg,

594: -- Cursor to fetch Termination date
595: cursor csr_terminated_date is
596: select serv.actual_termination_date actual_termination_date
597: from
598: per_all_assignments_f asg,
599: per_periods_of_service serv
600: where asg.assignment_id = p_person_rec.assignment_id
601: and asg.period_of_service_id = serv.period_of_service_id
602: and p_effective_date between asg.effective_start_date and asg.effective_end_date

Line 609: FROM per_all_assignments_f paaf,

605: --Below cursor fetches the termination date of the current assignment
606: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
607: IS
608: SELECT min(paaf.effective_start_date) min_active_start_date
609: FROM per_all_assignments_f paaf,
610: per_assignment_status_types past
611: WHERE paaf.assignment_id = p_asg_id
612: AND paaf.assignment_status_type_id = past.assignment_status_type_id
613: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 943: per_all_assignments_f asg

939: IS
940: SELECT trim(asg.primary_flag) asg_primary_flag,
941: trim(pap.per_information10) per_agg_flag
942: FROM per_all_people_f pap,
943: per_all_assignments_f asg
944: WHERE asg.assignment_id = c_asg_id
945: AND pap.person_id = asg.person_id
946: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
947: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;

Line 1291: per_all_assignments_f asg

1287: SELECT trim(asg.primary_flag) asg_primary_flag,
1288: trim(pap.per_information10) per_agg_flag,
1289: trim(pap.per_information9) per_ni_flag
1290: FROM per_all_people_f pap,
1291: per_all_assignments_f asg
1292: WHERE asg.assignment_id = c_asg_id
1293: AND pap.person_id = asg.person_id
1294: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
1295: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;

Line 1319: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,

1315: -- Cursor to fetch the RTI NI Reporting assignment for this person.
1316: cursor csr_get_ni_rpt_asg(c_asg_id number) is
1317: select
1318: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
1319: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
1320: pay_all_payrolls_f pay,
1321: hr_soft_coding_keyflex sck
1322: where paaf1.assignment_id = c_asg_id
1323: and paaf1.person_id = paaf2.person_id

Line 1334: from per_all_assignments_f asg2

1330: and upper(g_tax_ref) = upper(sck.segment1)
1331: and p_effective_date between pay.effective_start_date and pay.effective_end_date
1332: AND paaf1.effective_start_date =
1333: ( select max(asg2.effective_start_date)
1334: from per_all_assignments_f asg2
1335: where asg2.assignment_id = paaf1.assignment_id
1336: and asg2.assignment_type = 'E'
1337: and asg2.effective_start_date <= g_end_year
1338: )

Line 1341: from per_all_assignments_f asg2

1337: and asg2.effective_start_date <= g_end_year
1338: )
1339: AND paaf2.effective_start_date =
1340: ( select max(asg2.effective_start_date)
1341: from per_all_assignments_f asg2
1342: where asg2.assignment_id = paaf2.assignment_id
1343: and asg2.assignment_type = 'E'
1344: and asg2.effective_start_date <= g_end_year
1345: )

Line 2078: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_archive_tab(0).person_id)

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'
2081: and ACTION_INFORMATION30 = 'Y'
2082: and ACTION_CONTEXT_TYPE = 'AAP'

Line 2321: and paa.ASSIGNMENT_ID in (select distinct assignment_id from per_all_assignments_f where person_id = p_person_id)

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'
2324: and ACTION_INFORMATION30 = 'Y'
2325: and ACTION_CONTEXT_TYPE = 'AAP'

Line 3852: per_all_assignments_f asg,

3848: CURSOR csr_asg is
3849: select distinct asg.assignment_id assignment_id,trim(pap.per_information10) per_agg_flag,trim(pap.per_information9) per_ni_flag,
3850: pap.person_id person_id , asg.assignment_number l_asg_num
3851: from per_all_people_f pap,
3852: per_all_assignments_f asg,
3853: per_assignment_status_types past,
3854: pay_all_payrolls_f pay,
3855: hr_soft_coding_keyflex sck
3856: where pap.person_id between stperson and endperson

Line 3866: from per_all_assignments_f asg2

3862: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
3863: and upper(l_tax_ref) = upper(sck.segment1)
3864: and asg.effective_start_date =
3865: ( select max(asg2.effective_start_date)
3866: from per_all_assignments_f asg2
3867: where asg2.assignment_id = asg.assignment_id
3868: and asg2.assignment_type = 'E'
3869: and asg2.effective_start_date <= g_end_year
3870: )

Line 3935: per_all_assignments_f paaf,

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
3939: AND paaf.assignment_id = asg_id

Line 3945: from per_all_assignments_f asg2

3941: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
3942: and upper(l_tax_ref) = upper(sck.segment1)
3943: and paaf.effective_start_date =
3944: ( select max(asg2.effective_start_date)
3945: from per_all_assignments_f asg2
3946: where asg2.assignment_id = paaf.assignment_id
3947: and asg2.assignment_type = 'E'
3948: and asg2.effective_start_date <= g_end_year
3949: )

Line 3963: per_all_assignments_f paaf,

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,
3965: hr_soft_coding_keyflex sck
3966:
3967: WHERE paa.assignment_id = asg_id

Line 3974: from per_all_assignments_f asg2

3970: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
3971: and upper(l_tax_ref) = upper(sck.segment1)
3972: and paaf.effective_start_date =
3973: ( select max(asg2.effective_start_date)
3974: from per_all_assignments_f asg2
3975: where asg2.assignment_id = paaf.assignment_id
3976: and asg2.assignment_type = 'E'
3977: and asg2.effective_start_date <= g_end_year
3978: )

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 4007: from per_all_assignments_f asg2

4003: and ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4004: and ppa.PAYROLL_ACTION_ID > p_pact_id
4005: AND paaf.effective_start_date =
4006: ( select max(asg2.effective_start_date)
4007: from per_all_assignments_f asg2
4008: where asg2.assignment_id = paaf.assignment_id
4009: and asg2.assignment_type = 'E'
4010: and asg2.effective_start_date <= g_end_year
4011: )

Line 4016: FROM per_all_assignments_f paaf,

4012: and ppa.EFFECTIVE_DATE <= g_end_year;
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,

Line 4038: from per_all_assignments_f asg2

4034: BETWEEN g_start_year
4035: AND g_end_year
4036: AND paaf.effective_start_date =
4037: ( select max(asg2.effective_start_date)
4038: from per_all_assignments_f asg2
4039: where asg2.assignment_id = paaf.assignment_id
4040: and asg2.assignment_type = 'E'
4041: and asg2.effective_start_date <= g_end_year
4042: );

Line 4053: FROM per_all_assignments_f paaf,

4049: , '0')
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,

Line 4075: from per_all_assignments_f asg2

4071: BETWEEN g_start_year
4072: AND g_end_year
4073: AND paaf.effective_start_date =
4074: ( select max(asg2.effective_start_date)
4075: from per_all_assignments_f asg2
4076: where asg2.assignment_id = paaf.assignment_id
4077: and asg2.assignment_type = 'E'
4078: and asg2.effective_start_date <= g_end_year
4079: );

Line 4090: FROM per_all_assignments_f paaf,

4086: , '0')
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,

Line 4113: from per_all_assignments_f asg2

4109: BETWEEN g_start_year
4110: AND g_end_year
4111: AND paaf.effective_start_date =
4112: ( select max(asg2.effective_start_date)
4113: from per_all_assignments_f asg2
4114: where asg2.assignment_id = paaf.assignment_id
4115: and asg2.assignment_type = 'E'
4116: and asg2.effective_start_date <= g_end_year
4117: );

Line 4131: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,

4127: -- Cursor to fetch the RTI NI Reporting assignment for this person.
4128: cursor csr_get_ni_rpt_asg(c_asg_id number) is
4129: select
4130: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
4131: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
4132: pay_all_payrolls_f pay,
4133: hr_soft_coding_keyflex sck
4134: where paaf1.assignment_id = c_asg_id
4135: and paaf1.person_id = paaf2.person_id

Line 4146: from per_all_assignments_f asg2

4142: and upper(l_tax_ref) = upper(sck.segment1)
4143: and l_effective_date between pay.effective_start_date and pay.effective_end_date
4144: AND paaf1.effective_start_date =
4145: ( select max(asg2.effective_start_date)
4146: from per_all_assignments_f asg2
4147: where asg2.assignment_id = paaf1.assignment_id
4148: and asg2.assignment_type = 'E'
4149: and asg2.effective_start_date <= g_end_year
4150: )

Line 4153: from per_all_assignments_f asg2

4149: and asg2.effective_start_date <= g_end_year
4150: )
4151: AND paaf2.effective_start_date =
4152: ( select max(asg2.effective_start_date)
4153: from per_all_assignments_f asg2
4154: where asg2.assignment_id = paaf2.assignment_id
4155: and asg2.assignment_type = 'E'
4156: and asg2.effective_start_date <= g_end_year
4157: )

Line 5352: per_all_assignments_f paaf,

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
5356: and pap.person_id = paaf.person_id

Line 5359: from per_all_assignments_f asg2

5355: and paaf.assignment_id = paa.assignment_id
5356: and pap.person_id = paaf.person_id
5357: and paaf.effective_start_date =
5358: ( select max(asg2.effective_start_date)
5359: from per_all_assignments_f asg2
5360: where asg2.assignment_id = paaf.assignment_id
5361: and asg2.assignment_type = 'E'
5362: and asg2.effective_start_date <= g_end_year
5363: )

Line 5396: FROM per_all_assignments_f paaf,

5392: , '0')
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,

Line 5417: from per_all_assignments_f asg2

5413: BETWEEN g_start_year
5414: AND g_end_year
5415: AND paaf.effective_start_date =
5416: ( select max(asg2.effective_start_date)
5417: from per_all_assignments_f asg2
5418: where asg2.assignment_id = paaf.assignment_id
5419: and asg2.assignment_type = 'E'
5420: and asg2.effective_start_date <= g_end_year
5421: );

Line 5440: per_all_assignments_f paaf ,

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
5443: where paaf.person_id = per_id
5444: AND pay.payroll_id = paaf.payroll_id

Line 5453: from per_all_assignments_f asg2

5449: and ppa.payroll_action_id = paa.payroll_action_id
5450: and ppa.report_type in ( 'RTI_FPS_REP' , 'RTI_EYU_REP_13')
5451: and paaf.effective_start_date =
5452: ( select max(asg2.effective_start_date)
5453: from per_all_assignments_f asg2
5454: where asg2.assignment_id = paaf.assignment_id
5455: and asg2.assignment_type = 'E'
5456: and asg2.effective_start_date <= g_end_year
5457: )

Line 6005: FROM per_all_assignments_f paa,

6001: NVL(pap.employee_number,' ') employee_number,
6002: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
6003: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
6004: pap.person_id
6005: FROM per_all_assignments_f paa,
6006: per_assignment_status_types past,
6007: per_all_people_f pap
6008: WHERE paa.person_id = pap.person_id
6009: AND paa.assignment_id = c_assignment_id

Line 6020: from per_all_assignments_f asg2

6016: and pap2.effective_start_date <= g_end_year
6017: )
6018: and paa.effective_start_date =
6019: ( select max(asg2.effective_start_date)
6020: from per_all_assignments_f asg2
6021: where asg2.assignment_id = paa.assignment_id
6022: and asg2.assignment_type = 'E'
6023: and ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
6024: and asg2.effective_start_date <= g_end_year

Line 6123: per_all_assignments_f paaf

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'
6127: AND paaf.assignment_id = paa.assignment_id;