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_FPS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 386: select AEI_INFORMATION2 from per_assignment_extra_info

382: l_hours_worked_asg number;
383: l_asg_eff_date date;
384: l_irregular varchar2(2):= 'N';
385: cursor csr_normal_hours is
386: select AEI_INFORMATION2 from per_assignment_extra_info
387: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
388: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
389:
390: cursor csr_stnd_cond(c_asg_id number) is

Line 479: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

475: - Formula Function
476: **/
477: IF l_source_name = 'Assignment Developer DF' THEN
478: l_sqlstr := 'select ' || l_column_name ||
479: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
480: begin
481: EXECUTE immediate l_sqlstr INTO l_hours_worked USING p_assignment_id,l_context_name;
482: exception
483: WHEN OTHERS THEN

Line 642: select AEI_INFORMATION1 from per_assignment_extra_info

638: l_frequency VARCHAR2(20);
639: l_effective_date date;
640:
641: cursor csr_periods_covered_eit is
642: select AEI_INFORMATION1 from per_assignment_extra_info
643: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
644: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
645:
646: cursor csr_asg_start_date is

Line 700: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

696: - Formula Function
697: **/
698: IF l_source_name = 'Assignment Developer DF' THEN
699: l_sqlstr := 'select ' || l_column_name ||
700: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
701: begin
702:
703: hr_utility.trace('string '||l_sqlstr);
704: EXECUTE immediate l_sqlstr INTO l_periods_covered USING p_assignment_id,l_context_name;

Line 796: select AEI_INFORMATION3 from per_assignment_extra_info

792: l_frequency VARCHAR2(20);
793: l_effective_date date;
794:
795: cursor csr_irregular_payment_eit is
796: select AEI_INFORMATION3 from per_assignment_extra_info
797: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
798: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
799:
800: cursor csr_asg_start_date is

Line 854: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

850: - Formula Function
851: **/
852: IF l_source_name = 'Assignment Developer DF' THEN
853: l_sqlstr := 'select ' || l_column_name ||
854: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
855: begin
856:
857: hr_utility.trace('string '||l_sqlstr);
858: EXECUTE immediate l_sqlstr INTO l_irregular_payment USING p_assignment_id,l_context_name;

Line 952: select AEI_INFORMATION4 from per_assignment_extra_info

948: l_frequency VARCHAR2(20);
949: l_effective_date date;
950:
951: cursor csr_oneoff_payment_eit is
952: select AEI_INFORMATION4 from per_assignment_extra_info
953: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
954: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
955:
956: cursor csr_asg_start_date is

Line 1010: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

1006: - Formula Function
1007: **/
1008: IF l_source_name = 'Assignment Developer DF' THEN
1009: l_sqlstr := 'select ' || l_column_name ||
1010: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
1011: begin
1012:
1013: hr_utility.trace('string '||l_sqlstr);
1014: EXECUTE immediate l_sqlstr INTO l_oneoff_payment USING p_assignment_id,l_context_name;

Line 1362: FROM PER_ASSIGNMENT_EXTRA_INFO

1358: AEI_INFORMATION3 irr_payment ,
1359: AEI_INFORMATION4 "One-Off Payment",
1360: ASSIGNMENT_EXTRA_INFO_ID,
1361: object_version_number
1362: FROM PER_ASSIGNMENT_EXTRA_INFO
1363: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
1364: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
1365: AND assignment_id = p_person_rec.assignment_id;
1366:

Line 1382: FROM per_assignment_extra_info

1378: aei_information8 starter_flag,
1379: aei_information10 continue_with_student_loan,
1380: aei_information8 not_paid_between,
1381: object_version_number object_version_number
1382: FROM per_assignment_extra_info
1383: WHERE assignment_id = p_asg_id
1384: AND information_type = 'GB_RTI_ASG_DETAILS';
1385:
1386: --Below cursor fetches the pension details of the current assignment

Line 1395: FROM per_assignment_extra_info

1391: aei_information12 date_pension_started,
1392: trim(aei_information13) annual_pension,
1393: aei_information14 recently_bereaved,
1394: object_version_number object_version_number
1395: FROM per_assignment_extra_info
1396: WHERE assignment_id = p_asg_id
1397: AND information_type = 'GB_RTI_ASG_DETAILS';
1398:
1399: --Below cursor fetches the expat details of the current assignment

Line 1409: FROM per_assignment_extra_info

1405: aei_information17 eea_cw_citizen,
1406: aei_information18 epm6_scheme,
1407: aei_information19 expat_flag,
1408: object_version_number object_version_number
1409: FROM per_assignment_extra_info
1410: WHERE assignment_id = p_asg_id
1411: AND information_type = 'GB_RTI_ASG_DETAILS';
1412:
1413: --Below cursor fetches the assignment numbers of the current assignment

Line 2180: FROM PER_ASSIGNMENT_EXTRA_INFO

2176: AEI_INFORMATION3 irr_payment ,
2177: AEI_INFORMATION4 "One-Off Payment",
2178: ASSIGNMENT_EXTRA_INFO_ID,
2179: object_version_number
2180: FROM PER_ASSIGNMENT_EXTRA_INFO
2181: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
2182: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
2183: AND assignment_id = p_person_rec.assignment_id;
2184:

Line 2200: FROM per_assignment_extra_info

2196: aei_information8 starter_flag,
2197: aei_information10 continue_with_student_loan,
2198: aei_information8 not_paid_between,
2199: object_version_number object_version_number
2200: FROM per_assignment_extra_info
2201: WHERE assignment_id = p_asg_id
2202: AND information_type = 'GB_RTI_ASG_DETAILS';
2203:
2204: --Below cursor fetches the pension details of the current assignment

Line 2213: FROM per_assignment_extra_info

2209: aei_information12 date_pension_started,
2210: trim(aei_information13) annual_pension,
2211: aei_information14 recently_bereaved,
2212: object_version_number object_version_number
2213: FROM per_assignment_extra_info
2214: WHERE assignment_id = p_asg_id
2215: AND information_type = 'GB_RTI_ASG_DETAILS';
2216:
2217: --Below cursor fetches the expat details of the current assignment

Line 2227: FROM per_assignment_extra_info

2223: aei_information17 eea_cw_citizen,
2224: aei_information18 epm6_scheme,
2225: aei_information19 expat_flag,
2226: object_version_number object_version_number
2227: FROM per_assignment_extra_info
2228: WHERE assignment_id = p_asg_id
2229: AND information_type = 'GB_RTI_ASG_DETAILS';
2230:
2231: --Below cursor fetches the assignment numbers of the current assignment

Line 2993: FROM PER_ASSIGNMENT_EXTRA_INFO

2989: AEI_INFORMATION3 irr_payment ,
2990: AEI_INFORMATION4 "One-Off Payment",
2991: ASSIGNMENT_EXTRA_INFO_ID,
2992: object_version_number
2993: FROM PER_ASSIGNMENT_EXTRA_INFO
2994: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
2995: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
2996: AND assignment_id = l_asg_id;
2997:

Line 3013: FROM per_assignment_extra_info

3009: aei_information8 starter_flag,
3010: aei_information10 continue_with_student_loan,
3011: aei_information8 not_paid_between,
3012: object_version_number object_version_number
3013: FROM per_assignment_extra_info
3014: WHERE assignment_id = p_asg_id
3015: AND information_type = 'GB_RTI_ASG_DETAILS';
3016:
3017: --Below cursor fetches the pension details of the current assignment

Line 3026: FROM per_assignment_extra_info

3022: aei_information12 date_pension_started,
3023: trim(aei_information13) annual_pension,
3024: aei_information14 recently_bereaved,
3025: object_version_number object_version_number
3026: FROM per_assignment_extra_info
3027: WHERE assignment_id = p_asg_id
3028: AND information_type = 'GB_RTI_ASG_DETAILS';
3029:
3030: --Below cursor fetches the expat details of the current assignment

Line 3040: FROM per_assignment_extra_info

3036: aei_information17 eea_cw_citizen,
3037: aei_information18 epm6_scheme,
3038: aei_information19 expat_flag,
3039: object_version_number object_version_number
3040: FROM per_assignment_extra_info
3041: WHERE assignment_id = p_asg_id
3042: AND information_type = 'GB_RTI_ASG_DETAILS';
3043:
3044: --Below cursor fetches the assignment numbers of the current assignment

Line 3264: FROM per_assignment_extra_info

3260: --Cursor to fetch RTI Payroll ID for the assignment
3261: CURSOR csr_rti_payroll_id(cp_assignment_id NUMBER)
3262: IS
3263: SELECT aei_information3 rti_payroll_id
3264: FROM per_assignment_extra_info
3265: WHERE assignment_id = cp_assignment_id
3266: AND aei_information_category = 'GB_RTI_AGGREGATION';
3267:
3268: -- Cursor to fetch Director details for the person

Line 3894: FROM per_assignment_extra_info

3890: and p_payment_date between paaf.effective_start_date and paaf.effective_end_date;
3891:
3892: cursor csr_get_starter is
3893: SELECT aei_information8 starter_flag , aei_information1 starter_decl
3894: FROM per_assignment_extra_info
3895: WHERE assignment_id = p_asg_id
3896: AND information_type = 'GB_RTI_ASG_DETAILS';
3897:
3898: l_eff_start_date date;

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

6539: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'PAYROLL_ID'),1,20) = c_payroll_id;
6540:
6541: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
6542: cursor csr_ni_rpt_flag(c_asg_id number) is
6543: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id
6544: and AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION';
6545:
6546: -- Cursor to fetch the RTI NI Reporting assignment for this person.
6547: cursor csr_get_ni_rpt_asg(c_asg_id number) is

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

6546: -- Cursor to fetch the RTI NI Reporting assignment for this person.
6547: cursor csr_get_ni_rpt_asg(c_asg_id number) is
6548: select
6549: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
6550: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
6551: where paaf1.assignment_id = c_asg_id
6552: and paaf1.person_id = paaf2.person_id
6553: and paaf2.ASSIGNMENT_TYPE = 'E'
6554: and paei.assignment_id = paaf2.assignment_id

Line 7171: per_assignment_extra_info aei

7167: SELECT aei.assignment_extra_info_id,
7168: aei.object_version_number,
7169: aei.aei_information8
7170: FROM pay_assignment_actions paa,
7171: per_assignment_extra_info aei
7172: WHERE paa.assignment_action_id = p_assact
7173: AND aei.assignment_id = paa.assignment_id
7174: AND aei.information_type = p_type;
7175:

Line 7182: per_assignment_extra_info aei

7178: SELECT aei.assignment_extra_info_id,
7179: aei.object_version_number,
7180: aei.aei_information9
7181: FROM pay_assignment_actions paa,
7182: per_assignment_extra_info aei
7183: WHERE paa.assignment_action_id = p_assact
7184: AND aei.assignment_id = paa.assignment_id
7185: AND aei.information_type = p_type;
7186:

Line 7193: per_assignment_extra_info aei

7189: SELECT aei.assignment_extra_info_id,
7190: aei.object_version_number,
7191: aei.aei_information19
7192: FROM pay_assignment_actions paa,
7193: per_assignment_extra_info aei
7194: WHERE paa.assignment_action_id = p_assact
7195: AND aei.assignment_id = paa.assignment_id
7196: AND aei.information_type = p_type;
7197:

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

8505: from pay_assignment_actions
8506: where assignment_action_id = c_asgactid;
8507: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
8508: cursor csr_ni_rpt_flag(c_asg_id number) is
8509: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id
8510: and AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION';
8511:
8512: -- Cursor to fetch the RTI NI Reporting assignment for this person.
8513: cursor csr_get_ni_rpt_asg(c_asg_id number) is

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

8512: -- Cursor to fetch the RTI NI Reporting assignment for this person.
8513: cursor csr_get_ni_rpt_asg(c_asg_id number) is
8514: select
8515: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
8516: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
8517: where paaf1.assignment_id = c_asg_id
8518: and paaf1.person_id = paaf2.person_id
8519: and paaf2.ASSIGNMENT_TYPE = 'E'
8520: and paei.assignment_id = paaf2.assignment_id

Line 9133: FROM per_assignment_extra_info

9129: aei_information8 starter_flag,
9130: aei_information9 pensioner_flag,
9131: aei_information19 expat_flag,
9132: object_version_number l_ovn
9133: FROM per_assignment_extra_info
9134: WHERE assignment_id = p_asg_id
9135: AND information_type = 'GB_RTI_ASG_DETAILS';
9136:
9137: cursor csr_fps_check(p_asg_id number) is