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 220: FROM hr_all_organization_units

216: l_token varchar2(300);
217: l_number number;
218: CURSOR getbgid IS
219: SELECT business_group_id
220: FROM hr_all_organization_units
221: WHERE organization_id = p_organization_id;
222: /*
223: CURSOR orglocalunit IS
224: select o.organization_id

Line 307: from HR_ALL_ORGANIZATION_UNITS o1

303:
304:
305: CURSOR FIND_LEGAL_EMPLOYER IS
306: select hoi3.organization_id
307: from HR_ALL_ORGANIZATION_UNITS o1
308: , HR_ORGANIZATION_INFORMATION hoi1
309: , HR_ORGANIZATION_INFORMATION hoi2
310: , HR_ORGANIZATION_INFORMATION hoi3
311: WHERE o1.business_group_id =l_business_group_id

Line 325: from HR_ALL_ORGANIZATION_UNITS o1

321:
322: L_LEGAL_EMPLOYER NUMBER;
323: CURSOR ast_number IS
324: select count(hoi2.org_information1)
325: from HR_ALL_ORGANIZATION_UNITS o1
326: , HR_ORGANIZATION_INFORMATION hoi1
327: , HR_ORGANIZATION_INFORMATION hoi2
328: , HR_ORGANIZATION_INFORMATION hoi3
329: , HR_ORGANIZATION_INFORMATION hoi4

Line 390: from HR_ALL_ORGANIZATION_UNITS o1

386: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );*/
387:
388: CURSOR main_lc IS
389: select count(hoi2.org_information6)
390: from HR_ALL_ORGANIZATION_UNITS o1
391: , HR_ORGANIZATION_INFORMATION hoi1
392: , HR_ORGANIZATION_INFORMATION hoi2
393: , HR_ORGANIZATION_INFORMATION hoi3
394: , HR_ORGANIZATION_INFORMATION hoi4

Line 441: from HR_ALL_ORGANIZATION_UNITS o1

437: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
438: AND hoi3.organization_id = p_organization_id );
439: */
440: CURSOR main_lc_le IS select count(hoi2.org_information6)
441: from HR_ALL_ORGANIZATION_UNITS o1
442: , HR_ORGANIZATION_INFORMATION hoi1
443: , HR_ORGANIZATION_INFORMATION hoi2
444: , HR_ORGANIZATION_INFORMATION hoi3
445: , HR_ORGANIZATION_INFORMATION hoi4

Line 506: from HR_ALL_ORGANIZATION_UNITS o1

502: AND hoi3.organization_id = p_organization_id);
503: */
504: CURSOR ast_number_le IS
505: select count(hoi2.org_information1)
506: from HR_ALL_ORGANIZATION_UNITS o1
507: , HR_ORGANIZATION_INFORMATION hoi1
508: , HR_ORGANIZATION_INFORMATION hoi2
509: , HR_ORGANIZATION_INFORMATION hoi3
510: , HR_ORGANIZATION_INFORMATION hoi4

Line 531: from HR_ALL_ORGANIZATION_UNITS o1

527: and hoi2.org_information1 = hoi5.org_information1;
528:
529: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
530: select count(hoi1.org_information1)
531: from HR_ALL_ORGANIZATION_UNITS o1
532: , HR_ORGANIZATION_INFORMATION hoi1
533: , HR_ORGANIZATION_INFORMATION hoi2
534: WHERE o1.business_group_id =l_business_group_id
535: and o1.organization_id=hoi1.organization_id

Line 546: from HR_ALL_ORGANIZATION_UNITS o1

542: and hoi2.organization_id = p_organization_id;
543:
544: CURSOR absence_cat_limit(l_param1 varchar2) IS
545: select count(hoi1.org_information1)
546: from HR_ALL_ORGANIZATION_UNITS o1
547: , HR_ORGANIZATION_INFORMATION hoi1
548: , HR_ORGANIZATION_INFORMATION hoi2
549: WHERE o1.business_group_id =l_business_group_id
550: and o1.organization_id=hoi1.organization_id

Line 560: from HR_ALL_ORGANIZATION_UNITS o1

556: and hoi2.organization_id = p_organization_id;
557:
558: CURSOR org_number IS
559: select count(hoi2.org_information2)
560: from HR_ALL_ORGANIZATION_UNITS o1
561: , HR_ORGANIZATION_INFORMATION hoi1
562: , HR_ORGANIZATION_INFORMATION hoi2
563: WHERE o1.business_group_id =l_business_group_id
564: and hoi1.organization_id = o1.organization_id

Line 574: from HR_ALL_ORGANIZATION_UNITS o1

570: and hoi2.org_information2 = p_org_information2;
571:
572: CURSOR main_lc_status IS
573: select hoi2.org_information6
574: from HR_ALL_ORGANIZATION_UNITS o1
575: , HR_ORGANIZATION_INFORMATION hoi1
576: , HR_ORGANIZATION_INFORMATION hoi2
577: WHERE o1.business_group_id =l_business_group_id
578: and hoi1.organization_id = o1.organization_id

Line 589: FROM hr_organization_information hoi, hr_all_organization_units ou

585:
586:
587: CURSOR c_ins_le_ap_dtls IS
588: SELECT COUNT(*)
589: FROM hr_organization_information hoi, hr_all_organization_units ou
590: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
591: AND ou.organization_id = hoi.organization_id
592: AND ou.organization_id = nvl(p_organization_id , 0)
593: AND ou.business_group_id = l_business_group_id

Line 1069: FROM hr_all_organization_units

1065: INVALID_AGREEMENT_DECIMAL EXCEPTION;
1066: INVALID_AGREEMENT_NUM EXCEPTION;
1067: CURSOR getbgid IS
1068: SELECT business_group_id
1069: FROM hr_all_organization_units
1070: where organization_id = l_organization_id;
1071:
1072: CURSOR getorgid IS
1073: SELECT organization_id

Line 1161: from HR_ALL_ORGANIZATION_UNITS o1

1157: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );
1158: */
1159: CURSOR FIND_LEGAL_EMPLOYER IS
1160: select hoi3.organization_id
1161: from HR_ALL_ORGANIZATION_UNITS o1
1162: , HR_ORGANIZATION_INFORMATION hoi1
1163: , HR_ORGANIZATION_INFORMATION hoi2
1164: , HR_ORGANIZATION_INFORMATION hoi3
1165: WHERE o1.business_group_id =l_business_group_id

Line 1179: from HR_ALL_ORGANIZATION_UNITS o1

1175:
1176: L_LEGAL_EMPLOYER NUMBER;
1177: CURSOR ast_number IS
1178: select count(hoi2.org_information1)
1179: from HR_ALL_ORGANIZATION_UNITS o1
1180: , HR_ORGANIZATION_INFORMATION hoi1
1181: , HR_ORGANIZATION_INFORMATION hoi2
1182: , HR_ORGANIZATION_INFORMATION hoi3
1183: , HR_ORGANIZATION_INFORMATION hoi4

Line 1248: from HR_ALL_ORGANIZATION_UNITS o1

1244: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ) );
1245:
1246: */ CURSOR main_lc IS
1247: select count(hoi2.org_information6)
1248: from HR_ALL_ORGANIZATION_UNITS o1
1249: , HR_ORGANIZATION_INFORMATION hoi1
1250: , HR_ORGANIZATION_INFORMATION hoi2
1251: , HR_ORGANIZATION_INFORMATION hoi3
1252: , HR_ORGANIZATION_INFORMATION hoi4

Line 1300: from HR_ALL_ORGANIZATION_UNITS o1

1296: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1297: and hoi2.org_information_id <> p_org_information_id
1298: AND hoi3.organization_id = l_organization_id );*/
1299: CURSOR main_lc_le IS select count(hoi2.org_information6)
1300: from HR_ALL_ORGANIZATION_UNITS o1
1301: , HR_ORGANIZATION_INFORMATION hoi1
1302: , HR_ORGANIZATION_INFORMATION hoi2
1303: , HR_ORGANIZATION_INFORMATION hoi3
1304: , HR_ORGANIZATION_INFORMATION hoi4

Line 1366: from HR_ALL_ORGANIZATION_UNITS o1

1362: AND hoi3.organization_id = l_organization_id);
1363: */
1364: CURSOR ast_number_le IS
1365: select count(hoi2.org_information1)
1366: from HR_ALL_ORGANIZATION_UNITS o1
1367: , HR_ORGANIZATION_INFORMATION hoi1
1368: , HR_ORGANIZATION_INFORMATION hoi2
1369: , HR_ORGANIZATION_INFORMATION hoi3
1370: , HR_ORGANIZATION_INFORMATION hoi4

Line 1392: from HR_ALL_ORGANIZATION_UNITS o1

1388: and hoi2.org_information1 = hoi5.org_information1;
1389:
1390: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
1391: select count(hoi1.org_information1)
1392: from HR_ALL_ORGANIZATION_UNITS o1
1393: ,HR_ORGANIZATION_INFORMATION hoi1
1394: ,HR_ORGANIZATION_INFORMATION hoi2
1395: WHERE o1.business_group_id =l_business_group_id
1396: and o1.organization_id=hoi1.organization_id

Line 1408: from HR_ALL_ORGANIZATION_UNITS o1

1404: and hoi2.org_information_id <> p_org_information_id;
1405:
1406: CURSOR absence_cat_limit(l_param1 varchar2) IS
1407: select count(hoi1.org_information1)
1408: from HR_ALL_ORGANIZATION_UNITS o1
1409: ,HR_ORGANIZATION_INFORMATION hoi1
1410: ,HR_ORGANIZATION_INFORMATION hoi2
1411: WHERE o1.business_group_id =l_business_group_id
1412: and o1.organization_id=hoi1.organization_id

Line 1423: from HR_ALL_ORGANIZATION_UNITS o1

1419: and hoi2.org_information_id <> p_org_information_id;
1420:
1421: CURSOR org_number IS
1422: select count(hoi2.org_information2)
1423: from HR_ALL_ORGANIZATION_UNITS o1
1424: , HR_ORGANIZATION_INFORMATION hoi1
1425: , HR_ORGANIZATION_INFORMATION hoi2
1426: WHERE o1.business_group_id =l_business_group_id
1427: and hoi1.organization_id = o1.organization_id

Line 1438: from HR_ALL_ORGANIZATION_UNITS o1

1434: and hoi2.ORG_INFORMATION_CONTEXT='SE_LEGAL_EMPLOYER_DETAILS';
1435:
1436: CURSOR main_lc_status IS
1437: select hoi2.org_information6
1438: from HR_ALL_ORGANIZATION_UNITS o1
1439: , HR_ORGANIZATION_INFORMATION hoi1
1440: , HR_ORGANIZATION_INFORMATION hoi2
1441: WHERE o1.business_group_id =l_business_group_id
1442: and hoi1.organization_id = o1.organization_id

Line 1455: FROM hr_organization_information hoi, hr_all_organization_units ou

1451:
1452:
1453: CURSOR c_upd_le_ap_dtls IS
1454: SELECT COUNT(*)
1455: FROM hr_organization_information hoi, hr_all_organization_units ou
1456: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
1457: AND ou.organization_id = hoi.organization_id
1458: AND ou.organization_id = nvl(l_organization_id , 0)
1459: AND ou.business_group_id = l_business_group_id

Line 1930: FROM HR_all_ORGANIZATION_UNITS

1926:
1927: CURSOR get_int_or_ext_flag
1928: IS
1929: SELECT INTERNAL_EXTERNAL_FLAG
1930: FROM HR_all_ORGANIZATION_UNITS
1931: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
1932:
1933: BEGIN
1934: --