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

Line 144: FROM per_assignment_extra_info pae

140: CURSOR c_get_prev_amts
141: IS
142: SELECT pae.aei_information9,
143: pae.aei_information10
144: FROM per_assignment_extra_info pae
145: WHERE pae.assignment_extra_info_id = p_assignment_extra_info_id;
146:
147: CURSOR c_element(p_element_type_id NUMBER)
148: IS

Line 188: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

184: l_element_entry_id NUMBER := NULL ;
185: l_start_date DATE ;
186: l_end_date DATE ;
187: l_effective_start_date DATE ;
188: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
189: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
190: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
191: l_submitted NUMBER ;
192: l_prev_submitted NUMBER ;

Line 589: UPDATE per_assignment_extra_info

585: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
586:
587: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
588:
589: UPDATE per_assignment_extra_info
590: SET AEI_INFORMATION10 = P_EXEMPTED
591: ,AEI_INFORMATION6 = P_ER_COMMENTS
592: ,AEI_INFORMATION11 = nvl(l_element_entry_id,p_element_entry_id)
593: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;

Line 635: FROM per_assignment_extra_info pae

631: IS
632:
633: CURSOR csr_submitted_exempt IS
634: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
635: FROM per_assignment_extra_info pae
636: WHERE pae.assignment_id = p_assignment_id
637: AND pae.aei_information1 = p_tax_yr
638: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
639: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 649: FROM per_assignment_extra_info pae

645: AND pae.aei_information7 IS NOT NULL;
646:
647: CURSOR csr_submitted_unexempt IS
648: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
649: FROM per_assignment_extra_info pae
650: WHERE pae.assignment_id = p_assignment_id
651: AND pae.aei_information1 = p_tax_yr
652: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
653: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 714: FROM per_assignment_extra_info pae

710: IS
711:
712: CURSOR csr_submitted_exempt IS
713: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
714: FROM per_assignment_extra_info pae
715: WHERE pae.assignment_id = p_assignment_id
716: AND pae.aei_information1 = p_tax_yr
717: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
718: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 729: FROM per_assignment_extra_info pae

725: AND NVL(pae.aei_information18,'N') =nvl(p_carry_over,'N') ;
726:
727: CURSOR csr_submitted_unexempt IS
728: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
729: FROM per_assignment_extra_info pae
730: WHERE pae.assignment_id = p_assignment_id
731: AND pae.aei_information1 = p_tax_yr
732: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
733: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 793: FROM per_assignment_extra_info pae

789: IS
790:
791: CURSOR csr_submitted_exempt IS
792: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
793: FROM per_assignment_extra_info pae
794: WHERE pae.assignment_id = p_assignment_id
795: AND pae.aei_information1 = p_tax_yr
796: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
797: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 807: FROM per_assignment_extra_info pae

803: AND pae.aei_information7 IS NOT NULL;
804:
805: CURSOR csr_submitted_unexempt IS
806: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
807: FROM per_assignment_extra_info pae
808: WHERE pae.assignment_id = p_assignment_id
809: AND pae.aei_information1 = p_tax_yr
810: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
811: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 868: FROM per_assignment_extra_info pae

864: IS
865:
866: CURSOR csr_submitted_exempt IS
867: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information10)) submitted
868: FROM per_assignment_extra_info pae
869: WHERE pae.assignment_id = p_assignment_id
870: AND pae.aei_information1 = p_tax_yr
871: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
872: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 941: FROM per_assignment_extra_info pae

937:
938:
939: CURSOR csr_submitted_exempt IS
940: SELECT 'Y'
941: FROM per_assignment_extra_info pae
942: WHERE pae.assignment_id = p_assignment_id
943: AND pae.aei_information1 = p_tax_yr
944: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
945: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 955: FROM per_assignment_extra_info pae

951: AND pae.aei_information7 IS NOT NULL;
952:
953: CURSOR csr_submitted_unexempt IS
954: SELECT 'Y'
955: FROM per_assignment_extra_info pae
956: WHERE pae.assignment_id = p_assignment_id
957: AND pae.aei_information1 = p_tax_yr
958: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
959: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 1014: FROM per_assignment_extra_info extra

1010: /* CHANGE THIS CURSOR TO INCLUDE APPROVAL STATUS LATER */
1011: CURSOR csr_get_med_date_appr
1012: IS
1013: SELECT MAX(extra.last_update_date)
1014: FROM per_assignment_extra_info extra
1015: WHERE extra.information_type = 'PER_IN_MEDICAL_BILLS'
1016: and extra.aei_information1 = p_block
1017: AND extra.assignment_id = p_assignment_id
1018: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 1030: FROM per_assignment_extra_info extra

1026:
1027: CURSOR csr_get_ltc_date_appr
1028: IS
1029: SELECT MAX(extra.last_update_date)
1030: FROM per_assignment_extra_info extra
1031: WHERE extra.information_type = 'PER_IN_LTC_BILLS'
1032: and extra.aei_information1 = p_block
1033: AND extra.assignment_id = p_assignment_id
1034: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 1046: FROM per_assignment_extra_info extra

1042:
1043: CURSOR csr_get_med_date_unappr
1044: IS
1045: SELECT MAX(extra.last_update_date)
1046: FROM per_assignment_extra_info extra
1047: WHERE extra.information_type = 'PER_IN_MEDICAL_BILLS'
1048: and extra.aei_information1 = p_block
1049: AND extra.assignment_id = p_assignment_id
1050: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 1063: FROM per_assignment_extra_info extra

1059:
1060: CURSOR csr_get_ltc_date_unappr
1061: IS
1062: SELECT MAX(extra.last_update_date)
1063: FROM per_assignment_extra_info extra
1064: WHERE extra.information_type = 'PER_IN_LTC_BILLS'
1065: and extra.aei_information1 = p_block
1066: AND extra.assignment_id = p_assignment_id
1067: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))

Line 1242: FROM per_assignment_extra_info

1238: IS
1239: CURSOR csr_exists
1240: IS
1241: SELECT '1'
1242: FROM per_assignment_extra_info
1243: WHERE assignment_extra_info_id = p_asg_extra_info_id;
1244:
1245: l_ovn NUMBER;
1246: l_exists VARCHAR2(1);

Line 1252: DELETE FROM per_assignment_extra_info

1248: OPEN csr_exists;
1249: FETCH csr_exists INTO l_exists;
1250: IF csr_exists%FOUND THEN
1251:
1252: DELETE FROM per_assignment_extra_info
1253: WHERE assignment_extra_info_id = p_asg_extra_info_id;
1254: END IF;
1255:
1256: CLOSE csr_exists ;

Line 1287: FROM per_assignment_extra_info

1283:
1284: CURSOR csr_get_ovn(l_asg_extra_info_d NUMBER)
1285: IS
1286: SELECT object_version_number
1287: FROM per_assignment_extra_info
1288: WHERE assignment_extra_info_id = l_asg_extra_info_d;
1289:
1290:
1291: l_bill_amt NUMBER ;

Line 1686: from per_assignment_extra_info

1682: AND ppa.effective_date BETWEEN p_year_start AND p_year_end
1683: AND paa.source_action_id IS NOT NULL
1684: and exists(select '1' from pay_run_results prr
1685: where source_id in (select distinct(aei_information11)
1686: from per_assignment_extra_info
1687: where information_type ='PER_IN_MEDICAL_BILLS')
1688: and prr.assignment_action_id = paa.assignment_action_id) ;
1689:
1690: CURSOR csr_defined_balance_id(p_balance_name VARCHAR2,

Line 1835: UPDATE per_assignment_extra_info

1831: ,p_element_entry_id IN NUMBER DEFAULT NULL
1832: )
1833: IS
1834: BEGIN
1835: UPDATE per_assignment_extra_info
1836: SET
1837: AEI_INFORMATION21 = p_benefit,
1838: AEI_INFORMATION18 = p_carry
1839: where AEI_INFORMATION11 = p_element_entry_id

Line 1914: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

1910: l_count NUMBER;
1911: l_element_type_id NUMBER;
1912: l_start_date DATE ;
1913: l_end_date DATE ;
1914: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1915: l_session NUMBER ;
1916:
1917:
1918:

Line 2020: UPDATE per_assignment_extra_info

2016:
2017:
2018: END IF ;
2019:
2020: UPDATE per_assignment_extra_info
2021: SET AEI_INFORMATION18 = p_carry
2022: , AEI_INFORMATION21 = p_benefit
2023: where AEI_INFORMATION11 = p_element_entry_id
2024: and assignment_id = p_assignment_id;