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_AE_SI_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 9: FROM hr_organization_information

5: (p_business_group_id IN NUMBER) IS
6: /* Cursor to retrieve Currency */
7: CURSOR csr_currency IS
8: SELECT org_information10
9: FROM hr_organization_information
10: WHERE organization_id = p_business_group_id
11: AND org_information_context = 'Business Group Information';
12: l_currency VARCHAR2(40);
13: BEGIN

Line 84: FROM hr_organization_information

80:
81: /*Cursor for fetching Local nationality for the BG */
82: CURSOR csr_get_loc_nat IS
83: SELECT org_information1
84: FROM hr_organization_information
85: WHERE organization_id = p_business_group_id
86: AND org_information_context = 'AE_BG_DETAILS';
87:
88: /*Cursor for fetching Employer SSN*/

Line 91: FROM hr_organization_information

87:
88: /*Cursor for fetching Employer SSN*/
89: CURSOR csr_employer_ssn IS
90: SELECT org_information1
91: FROM hr_organization_information
92: WHERE organization_id = p_employer_id
93: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
94:
95: /*Cursor for fetching Employer Name*/

Line 104: FROM hr_organization_information hoi

100:
101: /* Cursor for fetching current employer type */
102: CURSOR csr_cur_employer_type IS
103: SELECT org_information6
104: FROM hr_organization_information hoi
105: WHERE hoi.organization_id = p_employer_id
106: AND hoi.org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
107:
108: /*Cursor for fetching Employer's PO Box and Emirate Code */

Line 125: FROM hr_organization_information hoi

121:
122: /* Cursor for fetching organization phone types */
123: CURSOR csr_get_org_phone_types (l_bg_id number) IS
124: SELECT hoi.org_information1,hoi.org_information2,hoi.org_information3,hoi.org_information4
125: FROM hr_organization_information hoi
126: WHERE hoi.organization_id = l_bg_id
127: AND hoi.org_information_context = 'AE_HR_BG_INFO';
128:
129: /* Cursor for fetching person's phone details */

Line 309: FROM HR_ORGANIZATION_INFORMATION

305:
306: /* Cursor for fetching Defined balance ids from Org EIT */
307: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
308: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
309: FROM HR_ORGANIZATION_INFORMATION
310: WHERE Organization_id = l_bg_id
311: AND org_information_context = 'AE_SI_DETAILS';
312:
313: /*Cursor for fetching defined balance id for subject_to_social_asg_run*/

Line 1224: FROM hr_organization_information

1220:
1221: /*Cursor for fetching Local nationality for the BG */
1222: CURSOR csr_get_loc_nat IS
1223: SELECT org_information1
1224: FROM hr_organization_information
1225: WHERE organization_id = p_business_group_id
1226: AND org_information_context = 'AE_BG_DETAILS';
1227:
1228: /*Cursor for fetching Employer SSN*/

Line 1231: FROM hr_organization_information

1227:
1228: /*Cursor for fetching Employer SSN*/
1229: CURSOR csr_employer_ssn IS
1230: SELECT org_information1
1231: FROM hr_organization_information
1232: WHERE organization_id = p_employer_id
1233: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
1234:
1235: /*Cursor for fetching Employer Name*/

Line 1244: FROM hr_organization_information hoi

1240:
1241: /* Cursor for fetching organization phone types */
1242: CURSOR csr_get_org_phone_types (l_bg_id number) IS
1243: SELECT hoi.org_information1,hoi.org_information2,hoi.org_information3,hoi.org_information4
1244: FROM hr_organization_information hoi
1245: WHERE hoi.organization_id = l_bg_id
1246: AND hoi.org_information_context = 'AE_HR_BG_INFO';
1247:
1248: /* Cursor for fetching person's phone details */

Line 1375: FROM HR_ORGANIZATION_INFORMATION

1371:
1372: /* Cursor for fetching Defined balance ids from Org EIT */
1373: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
1374: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10 ,ORG_INFORMATION11
1375: FROM HR_ORGANIZATION_INFORMATION
1376: WHERE Organization_id = l_bg_id
1377: AND org_information_context = 'AE_SI_DETAILS';
1378:
1379: /*Cursor for fetching defined balance id*/

Line 2083: FROM hr_organization_information

2079:
2080: /*Cursor for fetching Local nationality for the BG */
2081: CURSOR csr_get_loc_nat IS
2082: SELECT org_information1
2083: FROM hr_organization_information
2084: WHERE organization_id = p_business_group_id
2085: AND org_information_context = 'AE_BG_DETAILS';
2086:
2087: /*Cursor for fetching Employer SSN*/

Line 2090: FROM hr_organization_information

2086:
2087: /*Cursor for fetching Employer SSN*/
2088: CURSOR csr_employer_ssn IS
2089: SELECT org_information1
2090: FROM hr_organization_information
2091: WHERE organization_id = p_employer_id
2092: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
2093:
2094: /*Cursor for fetching Employer Name*/

Line 2144: FROM HR_ORGANIZATION_INFORMATION

2140:
2141: /* Cursor for fetching Defined balance ids from Org EIT */
2142: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
2143: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2144: FROM HR_ORGANIZATION_INFORMATION
2145: WHERE Organization_id = l_bg_id
2146: AND org_information_context = 'AE_SI_DETAILS';
2147:
2148: /* Cursor for fetching Subject to SI defined balance ID */

Line 2608: FROM hr_organization_information

2604:
2605: /*Cursor for fetching Local nationality for the BG */
2606: CURSOR csr_get_loc_nat IS
2607: SELECT org_information1
2608: FROM hr_organization_information
2609: WHERE organization_id = p_business_group_id
2610: AND org_information_context = 'AE_BG_DETAILS';
2611:
2612: /*Cursor for fetching Employer SSN*/

Line 2615: FROM hr_organization_information

2611:
2612: /*Cursor for fetching Employer SSN*/
2613: CURSOR csr_employer_ssn IS
2614: SELECT org_information1
2615: FROM hr_organization_information
2616: WHERE organization_id = p_employer_id
2617: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
2618:
2619: /*Cursor for fetching Employer Name*/

Line 2748: FROM HR_ORGANIZATION_INFORMATION

2744:
2745: /* Cursor for fetching Defined balance ids from Org EIT */
2746: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
2747: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2748: FROM HR_ORGANIZATION_INFORMATION
2749: WHERE Organization_id = l_bg_id
2750: AND org_information_context = 'AE_SI_DETAILS';
2751:
2752: /*Cursor for fetching defined balance id*/

Line 3793: FROM hr_organization_information

3789:
3790: /*Cursor for fetching Local nationality for the BG */
3791: CURSOR csr_get_loc_nat IS
3792: SELECT org_information1
3793: FROM hr_organization_information
3794: WHERE organization_id = p_business_group_id
3795: AND org_information_context = 'AE_BG_DETAILS';
3796:
3797: /*Cursor for fetching Employer Name*/

Line 3847: FROM HR_ORGANIZATION_INFORMATION

3843:
3844: /* Cursor for fetching Defined balance ids from Org EIT */
3845: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
3846: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
3847: FROM HR_ORGANIZATION_INFORMATION
3848: WHERE Organization_id = l_bg_id
3849: AND org_information_context = 'AE_SI_DETAILS';
3850:
3851: /* Cursor for fetching Defined balance ids for UAE balances */

Line 4563: FROM hr_organization_information

4559:
4560: /*Cursor for fetching Local nationality for the BG */
4561: CURSOR csr_get_loc_nat IS
4562: SELECT org_information1
4563: FROM hr_organization_information
4564: WHERE organization_id = p_business_group_id
4565: AND org_information_context = 'AE_BG_DETAILS';
4566:
4567: /*Cursor for fetching Employer Name*/

Line 4617: FROM HR_ORGANIZATION_INFORMATION

4613:
4614: /* Cursor for fetching Defined balance ids from Org EIT */
4615: CURSOR csr_get_def_bal_ids (l_bg_id number) IS
4616: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3,ORG_INFORMATION4,ORG_INFORMATION5,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
4617: FROM HR_ORGANIZATION_INFORMATION
4618: WHERE Organization_id = l_bg_id
4619: AND org_information_context = 'AE_SI_DETAILS';
4620:
4621: /* Cursor to retrieve Defined Balance Id */