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_ALL_ORGANIZATION_UNITS

Line 225: FROM hr_all_organization_units

221: l_token varchar2(300);
222: l_number number;
223: CURSOR getbgid IS
224: SELECT business_group_id
225: FROM hr_all_organization_units
226: WHERE organization_id = p_organization_id;
227: /*
228: CURSOR orglocalunit IS
229: select o.organization_id

Line 312: from HR_ALL_ORGANIZATION_UNITS o1

308:
309:
310: CURSOR FIND_LEGAL_EMPLOYER IS
311: select hoi3.organization_id
312: from HR_ALL_ORGANIZATION_UNITS o1
313: , HR_ORGANIZATION_INFORMATION hoi1
314: , HR_ORGANIZATION_INFORMATION hoi2
315: , HR_ORGANIZATION_INFORMATION hoi3
316: WHERE o1.business_group_id =l_business_group_id

Line 330: from HR_ALL_ORGANIZATION_UNITS o1

326:
327: L_LEGAL_EMPLOYER NUMBER;
328: CURSOR ast_number IS
329: select count(hoi2.org_information1)
330: from HR_ALL_ORGANIZATION_UNITS o1
331: , HR_ORGANIZATION_INFORMATION hoi1
332: , HR_ORGANIZATION_INFORMATION hoi2
333: , HR_ORGANIZATION_INFORMATION hoi3
334: , HR_ORGANIZATION_INFORMATION hoi4

Line 395: from HR_ALL_ORGANIZATION_UNITS o1

391: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );*/
392:
393: CURSOR main_lc IS
394: select count(hoi2.org_information6)
395: from HR_ALL_ORGANIZATION_UNITS o1
396: , HR_ORGANIZATION_INFORMATION hoi1
397: , HR_ORGANIZATION_INFORMATION hoi2
398: , HR_ORGANIZATION_INFORMATION hoi3
399: , HR_ORGANIZATION_INFORMATION hoi4

Line 446: from HR_ALL_ORGANIZATION_UNITS o1

442: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
443: AND hoi3.organization_id = p_organization_id );
444: */
445: CURSOR main_lc_le IS select count(hoi2.org_information6)
446: from HR_ALL_ORGANIZATION_UNITS o1
447: , HR_ORGANIZATION_INFORMATION hoi1
448: , HR_ORGANIZATION_INFORMATION hoi2
449: , HR_ORGANIZATION_INFORMATION hoi3
450: , HR_ORGANIZATION_INFORMATION hoi4

Line 511: from HR_ALL_ORGANIZATION_UNITS o1

507: AND hoi3.organization_id = p_organization_id);
508: */
509: CURSOR ast_number_le IS
510: select count(hoi2.org_information1)
511: from HR_ALL_ORGANIZATION_UNITS o1
512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4

Line 536: from HR_ALL_ORGANIZATION_UNITS o1

532: and hoi2.org_information1 = hoi5.org_information1;
533:
534: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
535: select count(hoi1.org_information1)
536: from HR_ALL_ORGANIZATION_UNITS o1
537: , HR_ORGANIZATION_INFORMATION hoi1
538: , HR_ORGANIZATION_INFORMATION hoi2
539: WHERE o1.business_group_id =l_business_group_id
540: and o1.organization_id=hoi1.organization_id

Line 551: from HR_ALL_ORGANIZATION_UNITS o1

547: and hoi2.organization_id = p_organization_id;
548:
549: CURSOR absence_cat_limit(l_param1 varchar2) IS
550: select count(hoi1.org_information1)
551: from HR_ALL_ORGANIZATION_UNITS o1
552: , HR_ORGANIZATION_INFORMATION hoi1
553: , HR_ORGANIZATION_INFORMATION hoi2
554: WHERE o1.business_group_id =l_business_group_id
555: and o1.organization_id=hoi1.organization_id

Line 565: from HR_ALL_ORGANIZATION_UNITS o1

561: and hoi2.organization_id = p_organization_id;
562:
563: CURSOR org_number IS
564: select count(hoi2.org_information2)
565: from HR_ALL_ORGANIZATION_UNITS o1
566: , HR_ORGANIZATION_INFORMATION hoi1
567: , HR_ORGANIZATION_INFORMATION hoi2
568: WHERE o1.business_group_id =l_business_group_id
569: and hoi1.organization_id = o1.organization_id

Line 579: from HR_ALL_ORGANIZATION_UNITS o1

575: and hoi2.org_information2 = p_org_information2;
576:
577: CURSOR main_lc_status IS
578: select hoi2.org_information6
579: from HR_ALL_ORGANIZATION_UNITS o1
580: , HR_ORGANIZATION_INFORMATION hoi1
581: , HR_ORGANIZATION_INFORMATION hoi2
582: WHERE o1.business_group_id =l_business_group_id
583: and hoi1.organization_id = o1.organization_id

Line 594: FROM hr_organization_information hoi, hr_all_organization_units ou

590:
591:
592: CURSOR c_ins_le_ap_dtls IS
593: SELECT COUNT(*)
594: FROM hr_organization_information hoi, hr_all_organization_units ou
595: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
596: AND ou.organization_id = hoi.organization_id
597: AND ou.organization_id = nvl(p_organization_id , 0)
598: AND ou.business_group_id = l_business_group_id

Line 1074: FROM hr_all_organization_units

1070: INVALID_AGREEMENT_DECIMAL EXCEPTION;
1071: INVALID_AGREEMENT_NUM EXCEPTION;
1072: CURSOR getbgid IS
1073: SELECT business_group_id
1074: FROM hr_all_organization_units
1075: where organization_id = l_organization_id;
1076:
1077: CURSOR getorgid IS
1078: SELECT organization_id

Line 1166: from HR_ALL_ORGANIZATION_UNITS o1

1162: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );
1163: */
1164: CURSOR FIND_LEGAL_EMPLOYER IS
1165: select hoi3.organization_id
1166: from HR_ALL_ORGANIZATION_UNITS o1
1167: , HR_ORGANIZATION_INFORMATION hoi1
1168: , HR_ORGANIZATION_INFORMATION hoi2
1169: , HR_ORGANIZATION_INFORMATION hoi3
1170: WHERE o1.business_group_id =l_business_group_id

Line 1184: from HR_ALL_ORGANIZATION_UNITS o1

1180:
1181: L_LEGAL_EMPLOYER NUMBER;
1182: CURSOR ast_number IS
1183: select count(hoi2.org_information1)
1184: from HR_ALL_ORGANIZATION_UNITS o1
1185: , HR_ORGANIZATION_INFORMATION hoi1
1186: , HR_ORGANIZATION_INFORMATION hoi2
1187: , HR_ORGANIZATION_INFORMATION hoi3
1188: , HR_ORGANIZATION_INFORMATION hoi4

Line 1253: from HR_ALL_ORGANIZATION_UNITS o1

1249: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );
1250:
1251: */ CURSOR main_lc IS
1252: select count(hoi2.org_information6)
1253: from HR_ALL_ORGANIZATION_UNITS o1
1254: , HR_ORGANIZATION_INFORMATION hoi1
1255: , HR_ORGANIZATION_INFORMATION hoi2
1256: , HR_ORGANIZATION_INFORMATION hoi3
1257: , HR_ORGANIZATION_INFORMATION hoi4

Line 1305: from HR_ALL_ORGANIZATION_UNITS o1

1301: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1302: and hoi2.org_information_id <> p_org_information_id
1303: AND hoi3.organization_id = l_organization_id );*/
1304: CURSOR main_lc_le IS select count(hoi2.org_information6)
1305: from HR_ALL_ORGANIZATION_UNITS o1
1306: , HR_ORGANIZATION_INFORMATION hoi1
1307: , HR_ORGANIZATION_INFORMATION hoi2
1308: , HR_ORGANIZATION_INFORMATION hoi3
1309: , HR_ORGANIZATION_INFORMATION hoi4

Line 1371: from HR_ALL_ORGANIZATION_UNITS o1

1367: AND hoi3.organization_id = l_organization_id);
1368: */
1369: CURSOR ast_number_le IS
1370: select count(hoi2.org_information1)
1371: from HR_ALL_ORGANIZATION_UNITS o1
1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4

Line 1397: from HR_ALL_ORGANIZATION_UNITS o1

1393: and hoi2.org_information1 = hoi5.org_information1;
1394:
1395: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
1396: select count(hoi1.org_information1)
1397: from HR_ALL_ORGANIZATION_UNITS o1
1398: ,HR_ORGANIZATION_INFORMATION hoi1
1399: ,HR_ORGANIZATION_INFORMATION hoi2
1400: WHERE o1.business_group_id =l_business_group_id
1401: and o1.organization_id=hoi1.organization_id

Line 1413: from HR_ALL_ORGANIZATION_UNITS o1

1409: and hoi2.org_information_id <> p_org_information_id;
1410:
1411: CURSOR absence_cat_limit(l_param1 varchar2) IS
1412: select count(hoi1.org_information1)
1413: from HR_ALL_ORGANIZATION_UNITS o1
1414: ,HR_ORGANIZATION_INFORMATION hoi1
1415: ,HR_ORGANIZATION_INFORMATION hoi2
1416: WHERE o1.business_group_id =l_business_group_id
1417: and o1.organization_id=hoi1.organization_id

Line 1428: from HR_ALL_ORGANIZATION_UNITS o1

1424: and hoi2.org_information_id <> p_org_information_id;
1425:
1426: CURSOR org_number IS
1427: select count(hoi2.org_information2)
1428: from HR_ALL_ORGANIZATION_UNITS o1
1429: , HR_ORGANIZATION_INFORMATION hoi1
1430: , HR_ORGANIZATION_INFORMATION hoi2
1431: WHERE o1.business_group_id =l_business_group_id
1432: and hoi1.organization_id = o1.organization_id

Line 1443: from HR_ALL_ORGANIZATION_UNITS o1

1439: and hoi2.ORG_INFORMATION_CONTEXT='SE_LEGAL_EMPLOYER_DETAILS';
1440:
1441: CURSOR main_lc_status IS
1442: select hoi2.org_information6
1443: from HR_ALL_ORGANIZATION_UNITS o1
1444: , HR_ORGANIZATION_INFORMATION hoi1
1445: , HR_ORGANIZATION_INFORMATION hoi2
1446: WHERE o1.business_group_id =l_business_group_id
1447: and hoi1.organization_id = o1.organization_id

Line 1460: FROM hr_organization_information hoi, hr_all_organization_units ou

1456:
1457:
1458: CURSOR c_upd_le_ap_dtls IS
1459: SELECT COUNT(*)
1460: FROM hr_organization_information hoi, hr_all_organization_units ou
1461: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
1462: AND ou.organization_id = hoi.organization_id
1463: AND ou.organization_id = nvl(l_organization_id , 0)
1464: AND ou.business_group_id = l_business_group_id

Line 1935: FROM HR_all_ORGANIZATION_UNITS

1931:
1932: CURSOR get_int_or_ext_flag
1933: IS
1934: SELECT INTERNAL_EXTERNAL_FLAG
1935: FROM HR_all_ORGANIZATION_UNITS
1936: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
1937:
1938: BEGIN
1939: --