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

Line 261: select AEI_INFORMATION2 from per_assignment_extra_info

257: l_hours_worked_asg number;
258: l_asg_eff_date date;
259: l_irregular varchar2(2):= 'N';
260: cursor csr_normal_hours is
261: select AEI_INFORMATION2 from per_assignment_extra_info
262: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
263: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
264:
265: cursor csr_stnd_cond(c_asg_id number) is

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

350: - Formula Function
351: **/
352: IF l_source_name = 'Assignment Developer DF' THEN
353: l_sqlstr := 'select ' || l_column_name ||
354: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
355: begin
356: EXECUTE immediate l_sqlstr INTO l_hours_worked USING p_assignment_id,l_context_name;
357: exception
358: WHEN OTHERS THEN

Line 517: select AEI_INFORMATION1 from per_assignment_extra_info

513: l_frequency VARCHAR2(20);
514: l_effective_date date;
515:
516: cursor csr_periods_covered_eit is
517: select AEI_INFORMATION1 from per_assignment_extra_info
518: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
519: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
520:
521: cursor csr_asg_start_date is

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

571: - Formula Function
572: **/
573: IF l_source_name = 'Assignment Developer DF' THEN
574: l_sqlstr := 'select ' || l_column_name ||
575: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
576: begin
577:
578: hr_utility.trace('string '||l_sqlstr);
579: EXECUTE immediate l_sqlstr INTO l_periods_covered USING p_assignment_id,l_context_name;

Line 671: select AEI_INFORMATION3 from per_assignment_extra_info

667: l_frequency VARCHAR2(20);
668: l_effective_date date;
669:
670: cursor csr_irregular_payment_eit is
671: select AEI_INFORMATION3 from per_assignment_extra_info
672: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
673: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
674:
675: cursor csr_asg_start_date is

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

725: - Formula Function
726: **/
727: IF l_source_name = 'Assignment Developer DF' THEN
728: l_sqlstr := 'select ' || l_column_name ||
729: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
730: begin
731:
732: hr_utility.trace('string '||l_sqlstr);
733: EXECUTE immediate l_sqlstr INTO l_irregular_payment USING p_assignment_id,l_context_name;

Line 827: select AEI_INFORMATION4 from per_assignment_extra_info

823: l_frequency VARCHAR2(20);
824: l_effective_date date;
825:
826: cursor csr_oneoff_payment_eit is
827: select AEI_INFORMATION4 from per_assignment_extra_info
828: where assignment_id = p_assignment_id and INFORMATION_TYPE = 'GB_PAY_RTI'
829: and AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI';
830:
831: cursor csr_asg_start_date is

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

881: - Formula Function
882: **/
883: IF l_source_name = 'Assignment Developer DF' THEN
884: l_sqlstr := 'select ' || l_column_name ||
885: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
886: begin
887:
888: hr_utility.trace('string '||l_sqlstr);
889: EXECUTE immediate l_sqlstr INTO l_oneoff_payment USING p_assignment_id,l_context_name;

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

1023: - Formula Function
1024: **/
1025: IF l_source_name = 'Assignment Developer DF' THEN
1026: l_sqlstr := 'select ' || l_column_name ||
1027: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
1028: begin
1029:
1030: hr_utility.trace('string '||l_sqlstr);
1031: EXECUTE immediate l_sqlstr INTO l_pay_non_indiv_ind USING p_assignment_id,l_context_name;

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

1165: - Formula Function
1166: **/
1167: IF l_source_name = 'Assignment Developer DF' THEN
1168: l_sqlstr := 'select ' || l_column_name ||
1169: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
1170: begin
1171:
1172: hr_utility.trace('string '||l_sqlstr);
1173: EXECUTE immediate l_sqlstr INTO l_onstrike_ind USING p_assignment_id,l_context_name;

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

1306: - Formula Function
1307: **/
1308: IF l_source_name = 'Assignment Developer DF' THEN
1309: l_sqlstr := 'select ' || l_column_name ||
1310: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
1311: begin
1312:
1313: hr_utility.trace('string '||l_sqlstr);
1314: EXECUTE immediate l_sqlstr INTO l_unpaid_absence_ind USING p_assignment_id,l_context_name;

Line 1650: FROM PER_ASSIGNMENT_EXTRA_INFO

1646: SELECT
1647: AEI_INFORMATION7 payment_nonindiv,
1648: AEI_INFORMATION8 onstrike ,
1649: AEI_INFORMATION9 unpaid_absence
1650: FROM PER_ASSIGNMENT_EXTRA_INFO
1651: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
1652: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
1653: AND assignment_id = l_asg_id;
1654:

Line 1872: FROM PER_ASSIGNMENT_EXTRA_INFO

1868: AEI_INFORMATION3 irr_payment ,
1869: AEI_INFORMATION4 "One-Off Payment",
1870: ASSIGNMENT_EXTRA_INFO_ID,
1871: object_version_number
1872: FROM PER_ASSIGNMENT_EXTRA_INFO
1873: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
1874: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
1875: AND assignment_id = p_person_rec.assignment_id;
1876:

Line 1892: FROM per_assignment_extra_info

1888: aei_information8 starter_flag,
1889: aei_information10 continue_with_student_loan,
1890: aei_information8 not_paid_between,
1891: object_version_number object_version_number
1892: FROM per_assignment_extra_info
1893: WHERE assignment_id = p_asg_id
1894: AND information_type = 'GB_RTI_ASG_DETAILS';
1895:
1896: --Below cursor fetches the pension details of the current assignment

Line 1905: FROM per_assignment_extra_info

1901: aei_information12 date_pension_started,
1902: trim(aei_information13) annual_pension,
1903: aei_information14 recently_bereaved,
1904: object_version_number object_version_number
1905: FROM per_assignment_extra_info
1906: WHERE assignment_id = p_asg_id
1907: AND information_type = 'GB_RTI_ASG_DETAILS';
1908:
1909: --Below cursor fetches the expat details of the current assignment

Line 1919: FROM per_assignment_extra_info

1915: aei_information17 eea_cw_citizen,
1916: aei_information18 epm6_scheme,
1917: aei_information19 expat_flag,
1918: object_version_number object_version_number
1919: FROM per_assignment_extra_info
1920: WHERE assignment_id = p_asg_id
1921: AND information_type = 'GB_RTI_ASG_DETAILS';
1922:
1923: --Below cursor fetches the assignment numbers of the current assignment

Line 2658: FROM PER_ASSIGNMENT_EXTRA_INFO

2654: AEI_INFORMATION3 irr_payment ,
2655: AEI_INFORMATION4 "One-Off Payment",
2656: ASSIGNMENT_EXTRA_INFO_ID,
2657: object_version_number
2658: FROM PER_ASSIGNMENT_EXTRA_INFO
2659: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
2660: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
2661: AND assignment_id = p_person_rec.assignment_id;
2662:

Line 2678: FROM per_assignment_extra_info

2674: aei_information8 starter_flag,
2675: aei_information10 continue_with_student_loan,
2676: aei_information8 not_paid_between,
2677: object_version_number object_version_number
2678: FROM per_assignment_extra_info
2679: WHERE assignment_id = p_asg_id
2680: AND information_type = 'GB_RTI_ASG_DETAILS';
2681:
2682: --Below cursor fetches the pension details of the current assignment

Line 2691: FROM per_assignment_extra_info

2687: aei_information12 date_pension_started,
2688: trim(aei_information13) annual_pension,
2689: aei_information14 recently_bereaved,
2690: object_version_number object_version_number
2691: FROM per_assignment_extra_info
2692: WHERE assignment_id = p_asg_id
2693: AND information_type = 'GB_RTI_ASG_DETAILS';
2694:
2695: --Below cursor fetches the expat details of the current assignment

Line 2705: FROM per_assignment_extra_info

2701: aei_information17 eea_cw_citizen,
2702: aei_information18 epm6_scheme,
2703: aei_information19 expat_flag,
2704: object_version_number object_version_number
2705: FROM per_assignment_extra_info
2706: WHERE assignment_id = p_asg_id
2707: AND information_type = 'GB_RTI_ASG_DETAILS';
2708:
2709: --Below cursor fetches the assignment numbers of the current assignment

Line 3460: FROM PER_ASSIGNMENT_EXTRA_INFO

3456: AEI_INFORMATION3 irr_payment ,
3457: AEI_INFORMATION4 "One-Off Payment",
3458: ASSIGNMENT_EXTRA_INFO_ID,
3459: object_version_number
3460: FROM PER_ASSIGNMENT_EXTRA_INFO
3461: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
3462: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
3463: AND assignment_id = l_asg_id;
3464:

Line 3480: FROM per_assignment_extra_info

3476: aei_information8 starter_flag,
3477: aei_information10 continue_with_student_loan,
3478: aei_information8 not_paid_between,
3479: object_version_number object_version_number
3480: FROM per_assignment_extra_info
3481: WHERE assignment_id = p_asg_id
3482: AND information_type = 'GB_RTI_ASG_DETAILS';
3483:
3484: --Below cursor fetches the pension details of the current assignment

Line 3493: FROM per_assignment_extra_info

3489: aei_information12 date_pension_started,
3490: trim(aei_information13) annual_pension,
3491: aei_information14 recently_bereaved,
3492: object_version_number object_version_number
3493: FROM per_assignment_extra_info
3494: WHERE assignment_id = p_asg_id
3495: AND information_type = 'GB_RTI_ASG_DETAILS';
3496:
3497: --Below cursor fetches the expat details of the current assignment

Line 3507: FROM per_assignment_extra_info

3503: aei_information17 eea_cw_citizen,
3504: aei_information18 epm6_scheme,
3505: aei_information19 expat_flag,
3506: object_version_number object_version_number
3507: FROM per_assignment_extra_info
3508: WHERE assignment_id = p_asg_id
3509: AND information_type = 'GB_RTI_ASG_DETAILS';
3510:
3511: --Below cursor fetches the assignment numbers of the current assignment

Line 3726: FROM per_assignment_extra_info

3722: --Cursor to fetch RTI Payroll ID for the assignment
3723: CURSOR csr_rti_payroll_id(cp_assignment_id NUMBER)
3724: IS
3725: SELECT aei_information3 rti_payroll_id
3726: FROM per_assignment_extra_info
3727: WHERE assignment_id = cp_assignment_id
3728: AND aei_information_category = 'GB_RTI_AGGREGATION';
3729:
3730: -- Cursor to fetch Director details for the person

Line 4470: FROM per_assignment_extra_info

4466: and p_payment_date between paaf.effective_start_date and paaf.effective_end_date;
4467:
4468: cursor csr_get_starter is
4469: SELECT aei_information8 starter_flag , aei_information1 starter_decl
4470: FROM per_assignment_extra_info
4471: WHERE assignment_id = p_asg_id
4472: AND information_type = 'GB_RTI_ASG_DETAILS';
4473:
4474: l_eff_start_date date;

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

7207: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'PAYROLL_ID'),1,20) = c_payroll_id;
7208:
7209: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
7210: cursor csr_ni_rpt_flag(c_asg_id number) is
7211: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id
7212: and AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION';
7213:
7214: -- Cursor to fetch the RTI NI Reporting assignment for this person.
7215: cursor csr_get_ni_rpt_asg(c_asg_id number) is

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

7214: -- Cursor to fetch the RTI NI Reporting assignment for this person.
7215: cursor csr_get_ni_rpt_asg(c_asg_id number) is
7216: select
7217: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
7218: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
7219: where paaf1.assignment_id = c_asg_id
7220: and paaf1.person_id = paaf2.person_id
7221: and paaf2.ASSIGNMENT_TYPE = 'E'
7222:

Line 7800: per_assignment_extra_info aei

7796: SELECT aei.assignment_extra_info_id,
7797: aei.object_version_number,
7798: aei.aei_information8
7799: FROM pay_assignment_actions paa,
7800: per_assignment_extra_info aei
7801: WHERE paa.assignment_action_id = p_assact
7802: AND aei.assignment_id = paa.assignment_id
7803: AND aei.information_type = p_type;
7804:

Line 7811: per_assignment_extra_info aei

7807: SELECT aei.assignment_extra_info_id,
7808: aei.object_version_number,
7809: aei.aei_information9
7810: FROM pay_assignment_actions paa,
7811: per_assignment_extra_info aei
7812: WHERE paa.assignment_action_id = p_assact
7813: AND aei.assignment_id = paa.assignment_id
7814: AND aei.information_type = p_type;
7815:

Line 7822: per_assignment_extra_info aei

7818: SELECT aei.assignment_extra_info_id,
7819: aei.object_version_number,
7820: aei.aei_information19
7821: FROM pay_assignment_actions paa,
7822: per_assignment_extra_info aei
7823: WHERE paa.assignment_action_id = p_assact
7824: AND aei.assignment_id = paa.assignment_id
7825: AND aei.information_type = p_type;
7826:

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

9139: from pay_assignment_actions
9140: where assignment_action_id = c_asgactid;
9141: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
9142: cursor csr_ni_rpt_flag(c_asg_id number) is
9143: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id
9144: and AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION';
9145:
9146: -- Cursor to fetch the RTI NI Reporting assignment for this person.
9147: cursor csr_get_ni_rpt_asg(c_asg_id number) is

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

9146: -- Cursor to fetch the RTI NI Reporting assignment for this person.
9147: cursor csr_get_ni_rpt_asg(c_asg_id number) is
9148: select
9149: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
9150: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
9151: where paaf1.assignment_id = c_asg_id
9152: and paaf1.person_id = paaf2.person_id
9153: and paaf2.ASSIGNMENT_TYPE = 'E'
9154:

Line 9769: FROM per_assignment_extra_info

9765: aei_information8 starter_flag,
9766: aei_information9 pensioner_flag,
9767: aei_information19 expat_flag,
9768: object_version_number l_ovn
9769: FROM per_assignment_extra_info
9770: WHERE assignment_id = p_asg_id
9771: AND information_type = 'GB_RTI_ASG_DETAILS';
9772:
9773: cursor csr_fps_check(p_asg_id number) is