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_ASSIGNMENT_EXTRA_INFO

Line 552: FROM per_assignment_extra_info

548: aei_information8 starter_flag,
549: aei_information10 continue_with_student_loan,
550: aei_information8 not_paid_between,
551: object_version_number object_version_number
552: FROM per_assignment_extra_info
553: WHERE assignment_id = p_asg_id
554: AND information_type = 'GB_RTI_ASG_DETAILS';
555:
556: --Below cursor fetches the pension details of the current assignment

Line 565: FROM per_assignment_extra_info

561: aei_information12 date_pension_started,
562: trim(aei_information13) annual_pension,
563: aei_information14 recently_bereaved,
564: object_version_number object_version_number
565: FROM per_assignment_extra_info
566: WHERE assignment_id = p_asg_id
567: AND information_type = 'GB_RTI_ASG_DETAILS';
568:
569: --Below cursor fetches the expat details of the current assignment

Line 579: FROM per_assignment_extra_info

575: aei_information17 eea_cw_citizen,
576: aei_information18 epm6_scheme,
577: aei_information19 expat_flag,
578: object_version_number object_version_number
579: FROM per_assignment_extra_info
580: WHERE assignment_id = p_asg_id
581: AND information_type = 'GB_RTI_ASG_DETAILS';
582: /*
583: cursor csr_fetch_asg_num is

Line 590: FROM per_assignment_extra_info

586: */
587: --Cursor to fetch RTI Payroll ID for the assignment
588: CURSOR csr_fetch_asg_num IS
589: SELECT aei_information3 rti_payroll_id
590: FROM per_assignment_extra_info
591: WHERE assignment_id = p_person_rec.assignment_id
592: AND aei_information_category = 'GB_RTI_AGGREGATION';
593:
594: -- Cursor to fetch Termination 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 2007: FROM PER_ASSIGNMENT_EXTRA_INFO

2003: --Below cursor fetches the nic_refund from asg extra details of the current assignment
2004: CURSOR csr_fetch_nic_refund
2005: IS
2006: SELECT AEI_INFORMATION10 nic_refund
2007: FROM PER_ASSIGNMENT_EXTRA_INFO
2008: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
2009: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
2010: AND assignment_id = p_asg_id;
2011:

Line 2012: l_nic_refund PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION10%type;

2008: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
2009: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
2010: AND assignment_id = p_asg_id;
2011:
2012: l_nic_refund PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION10%type;
2013:
2014: begin
2015: hr_utility.trace('Inside fetch_nic_refund');
2016:

Line 3693: FROM per_assignment_extra_info

3689: CURSOR csr_ovn
3690: IS
3691: SELECT object_version_number,
3692: assignment_extra_info_id
3693: FROM per_assignment_extra_info
3694: WHERE assignment_id = p_assig_id
3695: AND information_type = p_type;
3696: BEGIN
3697: hr_utility.set_location('Entering: '||l_proc,1);

Line 3879: FROM per_assignment_extra_info

3875: --Cursor to fetch RTI Payroll ID for the assignment
3876: CURSOR csr_rti_payroll_id(asg_id NUMBER)
3877: IS
3878: SELECT aei_information3 rti_payroll_id
3879: FROM per_assignment_extra_info
3880: WHERE assignment_id = asg_id
3881: AND aei_information_category = 'GB_RTI_AGGREGATION';
3882:
3883: --Cursor to fetch Latest FPS Run date for the assignment

Line 4124: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id

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
4125: and AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION';
4126:
4127: -- Cursor to fetch the RTI NI Reporting assignment for this person.
4128: cursor csr_get_ni_rpt_asg(c_asg_id number) is

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 4496: per_assignment_extra_info aei

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;
4500:

Line 4507: per_assignment_extra_info aei

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;
4511:

Line 4518: per_assignment_extra_info aei

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;
4522:

Line 5474: FROM per_assignment_extra_info

5470: aei_information8 starter_flag,
5471: aei_information9 pensioner_flag,
5472: aei_information19 expat_flag,
5473: object_version_number l_ovn
5474: FROM per_assignment_extra_info
5475: WHERE assignment_id = p_asg_id
5476: AND information_type = 'GB_RTI_ASG_DETAILS';
5477:
5478: cursor csr_fps_check(p_asg_id number) is