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 181: l_business_group_id hr_organization_units.business_group_id%TYPE;

177: ,p_org_information15 IN VARCHAR2 DEFAULT NULL
178: ,p_org_information16 IN VARCHAR2 DEFAULT null
179: ) IS
180:
181: l_business_group_id hr_organization_units.business_group_id%TYPE;
182: l_count NUMBER ;
183: l_field VARCHAR2(300) := NULL;
184: l_org_information1 hr_organization_information.org_information1%TYPE;
185: l_main_lc_status hr_organization_information.org_information6%TYPE;

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

221: WHERE organization_id = p_organization_id;
222: /*
223: CURSOR orglocalunit IS
224: select o.organization_id
225: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
226: where o.organization_id = hoi.organization_id
227: and hoi.org_information_context = 'CLASS'
228: and hoi.org_information1 = 'SE_LOCAL_UNIT'
229: and to_char(o.organization_id) in

Line 232: from hr_organization_units org, hr_organization_information hoinf

228: and hoi.org_information1 = 'SE_LOCAL_UNIT'
229: and to_char(o.organization_id) in
230: (
231: select hoinf.org_information1
232: from hr_organization_units org, hr_organization_information hoinf
233: where org.business_group_id = l_business_group_id
234: and org.organization_id = hoinf.organization_id
235: and hoinf.org_information_context = 'SE_LOCAL_UNITS'
236: )

Line 243: from hr_organization_units o ,

239: ORDER BY o.name;
240: */
241: CURSOR orglocalunit IS
242: select o.organization_id
243: from hr_organization_units o ,
244: hr_organization_information hoi,
245: hr_organization_information hoinf,
246: FND_SESSIONS s
247: where o.organization_id = hoi.organization_id

Line 260: from HR_ORGANIZATION_UNITS o1

256: ORDER BY o.name;
257: /*
258: CURSOR ast_number IS
259: select count(hoi2.org_information1)
260: from HR_ORGANIZATION_UNITS o1
261: , HR_ORGANIZATION_INFORMATION hoi1
262: , HR_ORGANIZATION_INFORMATION hoi2
263: WHERE o1.business_group_id =l_business_group_id
264: and hoi1.organization_id = o1.organization_id

Line 272: from HR_ORGANIZATION_UNITS o1

268: and hoi2.org_information1 = p_org_information1
269: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
270: and hoi1.organization_id in
271: (select hoi1.organization_id
272: from HR_ORGANIZATION_UNITS o1
273: , HR_ORGANIZATION_INFORMATION hoi1
274: , HR_ORGANIZATION_INFORMATION hoi2
275: , HR_ORGANIZATION_INFORMATION hoi3
276: WHERE o1.business_group_id =l_business_group_id

Line 287: from HR_ORGANIZATION_UNITS o1

283: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
284: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
285: AND hoi3.organization_id IN
286: (select hoi3.organization_id
287: from HR_ORGANIZATION_UNITS o1
288: , HR_ORGANIZATION_INFORMATION hoi1
289: , HR_ORGANIZATION_INFORMATION hoi2
290: , HR_ORGANIZATION_INFORMATION hoi3
291: WHERE o1.business_group_id =l_business_group_id

Line 346: from HR_ORGANIZATION_UNITS o1

342: and hoi4.organization_id = L_LEGAL_EMPLOYER;
343:
344: /* CURSOR main_lc IS
345: select count(hoi2.org_information6)
346: from HR_ORGANIZATION_UNITS o1
347: , HR_ORGANIZATION_INFORMATION hoi1
348: , HR_ORGANIZATION_INFORMATION hoi2
349: WHERE o1.business_group_id =l_business_group_id
350: and hoi1.organization_id = o1.organization_id

Line 358: from HR_ORGANIZATION_UNITS o1

354: and hoi2.org_information6 = 'Y'
355: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
356: and hoi1.organization_id in
357: (select hoi1.organization_id
358: from HR_ORGANIZATION_UNITS o1
359: , HR_ORGANIZATION_INFORMATION hoi1
360: , HR_ORGANIZATION_INFORMATION hoi2
361: , HR_ORGANIZATION_INFORMATION hoi3
362: WHERE o1.business_group_id =l_business_group_id

Line 373: from HR_ORGANIZATION_UNITS o1

369: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
370: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
371: AND hoi3.organization_id IN
372: (select hoi3.organization_id
373: from HR_ORGANIZATION_UNITS o1
374: , HR_ORGANIZATION_INFORMATION hoi1
375: , HR_ORGANIZATION_INFORMATION hoi2
376: , HR_ORGANIZATION_INFORMATION hoi3
377: WHERE o1.business_group_id =l_business_group_id

Line 412: from HR_ORGANIZATION_UNITS o1

408:
409: /*
410: CURSOR main_lc_le IS
411: select count(hoi2.org_information6)
412: from HR_ORGANIZATION_UNITS o1
413: , HR_ORGANIZATION_INFORMATION hoi1
414: , HR_ORGANIZATION_INFORMATION hoi2
415: WHERE o1.business_group_id =l_business_group_id
416: and hoi1.organization_id = o1.organization_id

Line 425: from HR_ORGANIZATION_UNITS o1

421: and hoi2.organization_id <> P_ORG_INFORMATION1
422: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
423: and hoi1.organization_id in
424: (select hoi1.organization_id
425: from HR_ORGANIZATION_UNITS o1
426: , HR_ORGANIZATION_INFORMATION hoi1
427: , HR_ORGANIZATION_INFORMATION hoi2
428: , HR_ORGANIZATION_INFORMATION hoi3
429: WHERE o1.business_group_id =l_business_group_id

Line 464: from HR_ORGANIZATION_UNITS o1

460:
461: /*
462: CURSOR ast_number_le IS
463: select count(hoi2.org_information1)
464: from HR_ORGANIZATION_UNITS o1
465: , HR_ORGANIZATION_INFORMATION hoi1
466: , HR_ORGANIZATION_INFORMATION hoi2
467: WHERE o1.business_group_id =l_business_group_id
468: and hoi1.organization_id = o1.organization_id

Line 476: from HR_ORGANIZATION_UNITS o1

472: and hoi2.organization_id <> P_ORG_INFORMATION1
473: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
474: and hoi2.org_information1 in
475: (select hoi2.org_information1
476: from HR_ORGANIZATION_UNITS o1
477: , HR_ORGANIZATION_INFORMATION hoi1
478: , HR_ORGANIZATION_INFORMATION hoi2
479: WHERE o1.business_group_id =l_business_group_id
480: and hoi1.organization_id = o1.organization_id

Line 489: from HR_ORGANIZATION_UNITS o1

485: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
486: )
487: and hoi1.organization_id in
488: (select hoi1.organization_id
489: from HR_ORGANIZATION_UNITS o1
490: , HR_ORGANIZATION_INFORMATION hoi1
491: , HR_ORGANIZATION_INFORMATION hoi2
492: , HR_ORGANIZATION_INFORMATION hoi3
493: WHERE o1.business_group_id =l_business_group_id

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

622: l_agreement_meaning varchar2(50);
623:
624: CURSOR csr_year IS
625: SELECT count(*)
626: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
627: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
628: AND ou.organization_id = hoi.organization_id
629: AND ou.organization_id = nvl (p_organization_id, 0)
630: AND ou.business_group_id = l_business_group_id

Line 1028: l_business_group_id hr_organization_units.business_group_id%TYPE;

1024: ,p_org_information16 IN VARCHAR2 DEFAULT null
1025: ) IS
1026:
1027: l_count NUMBER ;
1028: l_business_group_id hr_organization_units.business_group_id%TYPE;
1029: l_org_information1 hr_organization_information.org_information1%TYPE;
1030: l_field VARCHAR2(300) := NULL;
1031: l_organization_id hr_organization_information.organization_id%TYPE;
1032: l_main_lc_status hr_organization_information.org_information6%TYPE;

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

1076:
1077: /*
1078: CURSOR orglocalunit IS
1079: SELECT o.organization_id
1080: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
1081: WHERE o.organization_id = hoi.organization_id
1082: AND hoi.org_information_context = 'CLASS'
1083: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1084: AND to_char(o.organization_id) IN

Line 1087: FROM hr_organization_units org, hr_organization_information hoinf

1083: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1084: AND to_char(o.organization_id) IN
1085: (
1086: SELECT hoinf.org_information1
1087: FROM hr_organization_units org, hr_organization_information hoinf
1088: WHERE org.business_group_id = l_business_group_id
1089: AND org.organization_id = hoinf.organization_id
1090: AND org.organization_id <> l_organization_id
1091: AND hoinf.org_information_context = 'SE_LOCAL_UNITS'

Line 1099: from hr_organization_units o ,

1095: ORDER BY o.name;
1096: */
1097:
1098: CURSOR orglocalunit IS select o.organization_id
1099: from hr_organization_units o ,
1100: hr_organization_information hoi,
1101: hr_organization_information hoinf,
1102: FND_SESSIONS s
1103: where o.organization_id = hoi.organization_id

Line 1116: from HR_ORGANIZATION_UNITS o1

1112: ORDER BY o.name;
1113: /*
1114: CURSOR ast_number IS
1115: select count(hoi2.org_information1)
1116: from HR_ORGANIZATION_UNITS o1
1117: , HR_ORGANIZATION_INFORMATION hoi1
1118: , HR_ORGANIZATION_INFORMATION hoi2
1119: WHERE o1.business_group_id =l_business_group_id
1120: and hoi1.organization_id = o1.organization_id

Line 1129: from HR_ORGANIZATION_UNITS o1

1125: and hoi2.organization_id <> l_organization_id
1126: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1127: and hoi1.organization_id in
1128: (select hoi1.organization_id
1129: from HR_ORGANIZATION_UNITS o1
1130: , HR_ORGANIZATION_INFORMATION hoi1
1131: , HR_ORGANIZATION_INFORMATION hoi2
1132: , HR_ORGANIZATION_INFORMATION hoi3
1133: WHERE o1.business_group_id =l_business_group_id

Line 1144: from HR_ORGANIZATION_UNITS o1

1140: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
1141: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1142: AND hoi3.organization_id IN
1143: (select hoi3.organization_id
1144: from HR_ORGANIZATION_UNITS o1
1145: , HR_ORGANIZATION_INFORMATION hoi1
1146: , HR_ORGANIZATION_INFORMATION hoi2
1147: , HR_ORGANIZATION_INFORMATION hoi3
1148: WHERE o1.business_group_id =l_business_group_id

Line 1203: from HR_ORGANIZATION_UNITS o1

1199:
1200: /*
1201: CURSOR main_lc IS
1202: select count(hoi2.org_information6)
1203: from HR_ORGANIZATION_UNITS o1
1204: , HR_ORGANIZATION_INFORMATION hoi1
1205: , HR_ORGANIZATION_INFORMATION hoi2
1206: WHERE o1.business_group_id =l_business_group_id
1207: and hoi1.organization_id = o1.organization_id

Line 1216: from HR_ORGANIZATION_UNITS o1

1212: and hoi2.organization_id <> l_organization_id
1213: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1214: and hoi1.organization_id in
1215: (select hoi1.organization_id
1216: from HR_ORGANIZATION_UNITS o1
1217: , HR_ORGANIZATION_INFORMATION hoi1
1218: , HR_ORGANIZATION_INFORMATION hoi2
1219: , HR_ORGANIZATION_INFORMATION hoi3
1220: WHERE o1.business_group_id =l_business_group_id

Line 1231: from HR_ORGANIZATION_UNITS o1

1227: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
1228: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1229: AND hoi3.organization_id IN
1230: (select hoi3.organization_id
1231: from HR_ORGANIZATION_UNITS o1
1232: , HR_ORGANIZATION_INFORMATION hoi1
1233: , HR_ORGANIZATION_INFORMATION hoi2
1234: , HR_ORGANIZATION_INFORMATION hoi3
1235: WHERE o1.business_group_id =l_business_group_id

Line 1271: from HR_ORGANIZATION_UNITS o1

1267: /*
1268:
1269: CURSOR main_lc_le IS
1270: select count(hoi2.org_information6)
1271: from HR_ORGANIZATION_UNITS o1
1272: , HR_ORGANIZATION_INFORMATION hoi1
1273: , HR_ORGANIZATION_INFORMATION hoi2
1274: WHERE o1.business_group_id =l_business_group_id
1275: and hoi1.organization_id = o1.organization_id

Line 1284: from HR_ORGANIZATION_UNITS o1

1280: and hoi2.organization_id <> P_ORG_INFORMATION1
1281: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1282: and hoi1.organization_id in
1283: (select hoi1.organization_id
1284: from HR_ORGANIZATION_UNITS o1
1285: , HR_ORGANIZATION_INFORMATION hoi1
1286: , HR_ORGANIZATION_INFORMATION hoi2
1287: , HR_ORGANIZATION_INFORMATION hoi3
1288: WHERE o1.business_group_id =l_business_group_id

Line 1323: from HR_ORGANIZATION_UNITS o1

1319: AND hoi4.organization_id = l_organization_id ;
1320: /*
1321: CURSOR ast_number_le IS
1322: select count(hoi2.org_information1)
1323: from HR_ORGANIZATION_UNITS o1
1324: , HR_ORGANIZATION_INFORMATION hoi1
1325: , HR_ORGANIZATION_INFORMATION hoi2
1326: WHERE o1.business_group_id =l_business_group_id
1327: and hoi1.organization_id = o1.organization_id

Line 1335: from HR_ORGANIZATION_UNITS o1

1331: and hoi2.organization_id <> P_ORG_INFORMATION1
1332: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1333: and hoi2.org_information1 in
1334: (select hoi2.org_information1
1335: from HR_ORGANIZATION_UNITS o1
1336: , HR_ORGANIZATION_INFORMATION hoi1
1337: , HR_ORGANIZATION_INFORMATION hoi2
1338: WHERE o1.business_group_id =l_business_group_id
1339: and hoi1.organization_id = o1.organization_id

Line 1348: from HR_ORGANIZATION_UNITS o1

1344: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1345: )
1346: and hoi1.organization_id in
1347: (select hoi1.organization_id
1348: from HR_ORGANIZATION_UNITS o1
1349: , HR_ORGANIZATION_INFORMATION hoi1
1350: , HR_ORGANIZATION_INFORMATION hoi2
1351: , HR_ORGANIZATION_INFORMATION hoi3
1352: WHERE o1.business_group_id =l_business_group_id

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

1494: l_agreement_meaning varchar2(50);
1495:
1496: CURSOR csr_year IS
1497: SELECT count(*)
1498: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
1499: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
1500: AND ou.organization_id = hoi.organization_id
1501: AND ou.organization_id = nvl (l_organization_id, 0)
1502: AND ou.business_group_id = l_business_group_id

Line 1924: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;

1920: (P_ORGANIZATION_ID IN NUMBER
1921: ,P_ORG_INFORMATION1 IN VARCHAR2
1922: )IS
1923:
1924: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;
1925: INT_EXT_EXCEPTION exception;
1926:
1927: CURSOR get_int_or_ext_flag
1928: IS