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.HR_SE_VALIDATE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 186: l_business_group_id hr_organization_units.business_group_id%TYPE;

182: ,p_org_information15 IN VARCHAR2 DEFAULT NULL
183: ,p_org_information16 IN VARCHAR2 DEFAULT null
184: ) IS
185:
186: l_business_group_id hr_organization_units.business_group_id%TYPE;
187: l_count NUMBER ;
188: l_field VARCHAR2(300) := NULL;
189: l_org_information1 hr_organization_information.org_information1%TYPE;
190: l_main_lc_status hr_organization_information.org_information6%TYPE;

Line 230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

226: WHERE organization_id = p_organization_id;
227: /*
228: CURSOR orglocalunit IS
229: select o.organization_id
230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
231: where o.organization_id = hoi.organization_id
232: and hoi.org_information_context = 'CLASS'
233: and hoi.org_information1 = 'SE_LOCAL_UNIT'
234: and to_char(o.organization_id) in

Line 237: from hr_organization_units org, hr_organization_information hoinf

233: and hoi.org_information1 = 'SE_LOCAL_UNIT'
234: and to_char(o.organization_id) in
235: (
236: select hoinf.org_information1
237: from hr_organization_units org, hr_organization_information hoinf
238: where org.business_group_id = l_business_group_id
239: and org.organization_id = hoinf.organization_id
240: and hoinf.org_information_context = 'SE_LOCAL_UNITS'
241: )

Line 248: from hr_organization_units o ,

244: ORDER BY o.name;
245: */
246: CURSOR orglocalunit IS
247: select o.organization_id
248: from hr_organization_units o ,
249: hr_organization_information hoi,
250: hr_organization_information hoinf,
251: FND_SESSIONS s
252: where o.organization_id = hoi.organization_id

Line 265: from HR_ORGANIZATION_UNITS o1

261: ORDER BY o.name;
262: /*
263: CURSOR ast_number IS
264: select count(hoi2.org_information1)
265: from HR_ORGANIZATION_UNITS o1
266: , HR_ORGANIZATION_INFORMATION hoi1
267: , HR_ORGANIZATION_INFORMATION hoi2
268: WHERE o1.business_group_id =l_business_group_id
269: and hoi1.organization_id = o1.organization_id

Line 277: from HR_ORGANIZATION_UNITS o1

273: and hoi2.org_information1 = p_org_information1
274: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
275: and hoi1.organization_id in
276: (select hoi1.organization_id
277: from HR_ORGANIZATION_UNITS o1
278: , HR_ORGANIZATION_INFORMATION hoi1
279: , HR_ORGANIZATION_INFORMATION hoi2
280: , HR_ORGANIZATION_INFORMATION hoi3
281: WHERE o1.business_group_id =l_business_group_id

Line 292: from HR_ORGANIZATION_UNITS o1

288: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
289: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
290: AND hoi3.organization_id IN
291: (select hoi3.organization_id
292: from HR_ORGANIZATION_UNITS o1
293: , HR_ORGANIZATION_INFORMATION hoi1
294: , HR_ORGANIZATION_INFORMATION hoi2
295: , HR_ORGANIZATION_INFORMATION hoi3
296: WHERE o1.business_group_id =l_business_group_id

Line 351: from HR_ORGANIZATION_UNITS o1

347: and hoi4.organization_id = L_LEGAL_EMPLOYER;
348:
349: /* CURSOR main_lc IS
350: select count(hoi2.org_information6)
351: from HR_ORGANIZATION_UNITS o1
352: , HR_ORGANIZATION_INFORMATION hoi1
353: , HR_ORGANIZATION_INFORMATION hoi2
354: WHERE o1.business_group_id =l_business_group_id
355: and hoi1.organization_id = o1.organization_id

Line 363: from HR_ORGANIZATION_UNITS o1

359: and hoi2.org_information6 = 'Y'
360: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
361: and hoi1.organization_id in
362: (select hoi1.organization_id
363: from HR_ORGANIZATION_UNITS o1
364: , HR_ORGANIZATION_INFORMATION hoi1
365: , HR_ORGANIZATION_INFORMATION hoi2
366: , HR_ORGANIZATION_INFORMATION hoi3
367: WHERE o1.business_group_id =l_business_group_id

Line 378: from HR_ORGANIZATION_UNITS o1

374: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
375: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
376: AND hoi3.organization_id IN
377: (select hoi3.organization_id
378: from HR_ORGANIZATION_UNITS o1
379: , HR_ORGANIZATION_INFORMATION hoi1
380: , HR_ORGANIZATION_INFORMATION hoi2
381: , HR_ORGANIZATION_INFORMATION hoi3
382: WHERE o1.business_group_id =l_business_group_id

Line 417: from HR_ORGANIZATION_UNITS o1

413:
414: /*
415: CURSOR main_lc_le IS
416: select count(hoi2.org_information6)
417: from HR_ORGANIZATION_UNITS o1
418: , HR_ORGANIZATION_INFORMATION hoi1
419: , HR_ORGANIZATION_INFORMATION hoi2
420: WHERE o1.business_group_id =l_business_group_id
421: and hoi1.organization_id = o1.organization_id

Line 430: from HR_ORGANIZATION_UNITS o1

426: and hoi2.organization_id <> P_ORG_INFORMATION1
427: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
428: and hoi1.organization_id in
429: (select hoi1.organization_id
430: from HR_ORGANIZATION_UNITS o1
431: , HR_ORGANIZATION_INFORMATION hoi1
432: , HR_ORGANIZATION_INFORMATION hoi2
433: , HR_ORGANIZATION_INFORMATION hoi3
434: WHERE o1.business_group_id =l_business_group_id

Line 469: from HR_ORGANIZATION_UNITS o1

465:
466: /*
467: CURSOR ast_number_le IS
468: select count(hoi2.org_information1)
469: from HR_ORGANIZATION_UNITS o1
470: , HR_ORGANIZATION_INFORMATION hoi1
471: , HR_ORGANIZATION_INFORMATION hoi2
472: WHERE o1.business_group_id =l_business_group_id
473: and hoi1.organization_id = o1.organization_id

Line 481: from HR_ORGANIZATION_UNITS o1

477: and hoi2.organization_id <> P_ORG_INFORMATION1
478: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
479: and hoi2.org_information1 in
480: (select hoi2.org_information1
481: from HR_ORGANIZATION_UNITS o1
482: , HR_ORGANIZATION_INFORMATION hoi1
483: , HR_ORGANIZATION_INFORMATION hoi2
484: WHERE o1.business_group_id =l_business_group_id
485: and hoi1.organization_id = o1.organization_id

Line 494: from HR_ORGANIZATION_UNITS o1

490: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
491: )
492: and hoi1.organization_id in
493: (select hoi1.organization_id
494: from HR_ORGANIZATION_UNITS o1
495: , HR_ORGANIZATION_INFORMATION hoi1
496: , HR_ORGANIZATION_INFORMATION hoi2
497: , HR_ORGANIZATION_INFORMATION hoi3
498: WHERE o1.business_group_id =l_business_group_id

Line 631: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s

627: l_agreement_meaning varchar2(50);
628:
629: CURSOR csr_year IS
630: SELECT count(*)
631: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
632: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
633: AND ou.organization_id = hoi.organization_id
634: AND ou.organization_id = nvl (p_organization_id, 0)
635: AND ou.business_group_id = l_business_group_id

Line 1033: l_business_group_id hr_organization_units.business_group_id%TYPE;

1029: ,p_org_information16 IN VARCHAR2 DEFAULT null
1030: ) IS
1031:
1032: l_count NUMBER ;
1033: l_business_group_id hr_organization_units.business_group_id%TYPE;
1034: l_org_information1 hr_organization_information.org_information1%TYPE;
1035: l_field VARCHAR2(300) := NULL;
1036: l_organization_id hr_organization_information.organization_id%TYPE;
1037: l_main_lc_status hr_organization_information.org_information6%TYPE;

Line 1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

1081:
1082: /*
1083: CURSOR orglocalunit IS
1084: SELECT o.organization_id
1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
1086: WHERE o.organization_id = hoi.organization_id
1087: AND hoi.org_information_context = 'CLASS'
1088: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1089: AND to_char(o.organization_id) IN

Line 1092: FROM hr_organization_units org, hr_organization_information hoinf

1088: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1089: AND to_char(o.organization_id) IN
1090: (
1091: SELECT hoinf.org_information1
1092: FROM hr_organization_units org, hr_organization_information hoinf
1093: WHERE org.business_group_id = l_business_group_id
1094: AND org.organization_id = hoinf.organization_id
1095: AND org.organization_id <> l_organization_id
1096: AND hoinf.org_information_context = 'SE_LOCAL_UNITS'

Line 1104: from hr_organization_units o ,

1100: ORDER BY o.name;
1101: */
1102:
1103: CURSOR orglocalunit IS select o.organization_id
1104: from hr_organization_units o ,
1105: hr_organization_information hoi,
1106: hr_organization_information hoinf,
1107: FND_SESSIONS s
1108: where o.organization_id = hoi.organization_id

Line 1121: from HR_ORGANIZATION_UNITS o1

1117: ORDER BY o.name;
1118: /*
1119: CURSOR ast_number IS
1120: select count(hoi2.org_information1)
1121: from HR_ORGANIZATION_UNITS o1
1122: , HR_ORGANIZATION_INFORMATION hoi1
1123: , HR_ORGANIZATION_INFORMATION hoi2
1124: WHERE o1.business_group_id =l_business_group_id
1125: and hoi1.organization_id = o1.organization_id

Line 1134: from HR_ORGANIZATION_UNITS o1

1130: and hoi2.organization_id <> l_organization_id
1131: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1132: and hoi1.organization_id in
1133: (select hoi1.organization_id
1134: from HR_ORGANIZATION_UNITS o1
1135: , HR_ORGANIZATION_INFORMATION hoi1
1136: , HR_ORGANIZATION_INFORMATION hoi2
1137: , HR_ORGANIZATION_INFORMATION hoi3
1138: WHERE o1.business_group_id =l_business_group_id

Line 1149: from HR_ORGANIZATION_UNITS o1

1145: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
1146: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1147: AND hoi3.organization_id IN
1148: (select hoi3.organization_id
1149: from HR_ORGANIZATION_UNITS o1
1150: , HR_ORGANIZATION_INFORMATION hoi1
1151: , HR_ORGANIZATION_INFORMATION hoi2
1152: , HR_ORGANIZATION_INFORMATION hoi3
1153: WHERE o1.business_group_id =l_business_group_id

Line 1208: from HR_ORGANIZATION_UNITS o1

1204:
1205: /*
1206: CURSOR main_lc IS
1207: select count(hoi2.org_information6)
1208: from HR_ORGANIZATION_UNITS o1
1209: , HR_ORGANIZATION_INFORMATION hoi1
1210: , HR_ORGANIZATION_INFORMATION hoi2
1211: WHERE o1.business_group_id =l_business_group_id
1212: and hoi1.organization_id = o1.organization_id

Line 1221: from HR_ORGANIZATION_UNITS o1

1217: and hoi2.organization_id <> l_organization_id
1218: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1219: and hoi1.organization_id in
1220: (select hoi1.organization_id
1221: from HR_ORGANIZATION_UNITS o1
1222: , HR_ORGANIZATION_INFORMATION hoi1
1223: , HR_ORGANIZATION_INFORMATION hoi2
1224: , HR_ORGANIZATION_INFORMATION hoi3
1225: WHERE o1.business_group_id =l_business_group_id

Line 1236: from HR_ORGANIZATION_UNITS o1

1232: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
1233: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1234: AND hoi3.organization_id IN
1235: (select hoi3.organization_id
1236: from HR_ORGANIZATION_UNITS o1
1237: , HR_ORGANIZATION_INFORMATION hoi1
1238: , HR_ORGANIZATION_INFORMATION hoi2
1239: , HR_ORGANIZATION_INFORMATION hoi3
1240: WHERE o1.business_group_id =l_business_group_id

Line 1276: from HR_ORGANIZATION_UNITS o1

1272: /*
1273:
1274: CURSOR main_lc_le IS
1275: select count(hoi2.org_information6)
1276: from HR_ORGANIZATION_UNITS o1
1277: , HR_ORGANIZATION_INFORMATION hoi1
1278: , HR_ORGANIZATION_INFORMATION hoi2
1279: WHERE o1.business_group_id =l_business_group_id
1280: and hoi1.organization_id = o1.organization_id

Line 1289: from HR_ORGANIZATION_UNITS o1

1285: and hoi2.organization_id <> P_ORG_INFORMATION1
1286: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1287: and hoi1.organization_id in
1288: (select hoi1.organization_id
1289: from HR_ORGANIZATION_UNITS o1
1290: , HR_ORGANIZATION_INFORMATION hoi1
1291: , HR_ORGANIZATION_INFORMATION hoi2
1292: , HR_ORGANIZATION_INFORMATION hoi3
1293: WHERE o1.business_group_id =l_business_group_id

Line 1328: from HR_ORGANIZATION_UNITS o1

1324: AND hoi4.organization_id = l_organization_id ;
1325: /*
1326: CURSOR ast_number_le IS
1327: select count(hoi2.org_information1)
1328: from HR_ORGANIZATION_UNITS o1
1329: , HR_ORGANIZATION_INFORMATION hoi1
1330: , HR_ORGANIZATION_INFORMATION hoi2
1331: WHERE o1.business_group_id =l_business_group_id
1332: and hoi1.organization_id = o1.organization_id

Line 1340: from HR_ORGANIZATION_UNITS o1

1336: and hoi2.organization_id <> P_ORG_INFORMATION1
1337: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1338: and hoi2.org_information1 in
1339: (select hoi2.org_information1
1340: from HR_ORGANIZATION_UNITS o1
1341: , HR_ORGANIZATION_INFORMATION hoi1
1342: , HR_ORGANIZATION_INFORMATION hoi2
1343: WHERE o1.business_group_id =l_business_group_id
1344: and hoi1.organization_id = o1.organization_id

Line 1353: from HR_ORGANIZATION_UNITS o1

1349: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1350: )
1351: and hoi1.organization_id in
1352: (select hoi1.organization_id
1353: from HR_ORGANIZATION_UNITS o1
1354: , HR_ORGANIZATION_INFORMATION hoi1
1355: , HR_ORGANIZATION_INFORMATION hoi2
1356: , HR_ORGANIZATION_INFORMATION hoi3
1357: WHERE o1.business_group_id =l_business_group_id

Line 1503: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s

1499: l_agreement_meaning varchar2(50);
1500:
1501: CURSOR csr_year IS
1502: SELECT count(*)
1503: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
1504: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
1505: AND ou.organization_id = hoi.organization_id
1506: AND ou.organization_id = nvl (l_organization_id, 0)
1507: AND ou.business_group_id = l_business_group_id

Line 1929: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;

1925: (P_ORGANIZATION_ID IN NUMBER
1926: ,P_ORG_INFORMATION1 IN VARCHAR2
1927: )IS
1928:
1929: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;
1930: INT_EXT_EXCEPTION exception;
1931:
1932: CURSOR get_int_or_ext_flag
1933: IS