APPS.PJI_PMV_ENGINE dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1243: hr_all_organization_units_tl org,

1239: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1240: SELECT sub_organization_id,
1241: org.name
1242: FROM pji_org_denorm orgd,
1243: hr_all_organization_units_tl org,
1244: fnd_user fnd,
1245: per_all_assignments_f per
1246: WHERE org.language = USERENV('LANG')
1247: AND fnd.user_id=l_user_id

Line 1322: , hr_all_organization_units_tl org

1318: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1319: SELECT sub_organization_id
1320: , org.name
1321: FROM pji_org_denorm orgd
1322: , hr_all_organization_units_tl org
1323: WHERE 1=1
1324: AND org.language = USERENV('LANG')
1325: AND orgd.sub_organization_id = org.organization_id
1326: AND orgd.sub_organization_level-orgd.organization_level=1

Line 1343: , hr_all_organization_units_tl org

1339: SELECT sub_organization_id
1340: , org.name
1341: FROM pji_org_denorm orgd
1342: , per_organization_list sec
1343: , hr_all_organization_units_tl org
1344: WHERE 1=1
1345: AND org.language = USERENV('LANG')
1346: AND sec.security_profile_id = l_Security_Profile_ID
1347: AND orgd.sub_organization_id = org.organization_id

Line 1372: FROM hr_all_organization_units_tl

1368: END IF;
1369:
1370: SELECT name
1371: INTO l_Organization_Name
1372: FROM hr_all_organization_units_tl
1373: WHERE organization_id = p_Top_Organization_ID
1374: AND language = USERENV('LANG');
1375:
1376: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 1470: , hr_all_organization_units_tl org

1466: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1467: SELECT subro_organization_id
1468: , name
1469: FROM hri_cs_orghro_v orgd
1470: , hr_all_organization_units_tl org
1471: , pji_system_settings pjist
1472: WHERE 1=1
1473: AND pjist.setting_id = 1
1474: AND orgd.org_hierarchy_version_id = pjist.org_structure_version_id

Line 1494: , hr_all_organization_units_tl org

1490: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1491: SELECT subro_organization_id
1492: , name
1493: FROM hri_cs_orghro_v orgd
1494: , hr_all_organization_units_tl org
1495: , per_organization_list sec
1496: , pji_system_settings pjist
1497: WHERE 1=1
1498: AND pjist.setting_id = 1

Line 1526: FROM hr_all_organization_units_tl

1522:
1523:
1524: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1525: SELECT organization_id, name
1526: FROM hr_all_organization_units_tl
1527: WHERE organization_id = p_Top_Organization_ID
1528: AND language = USERENV('LANG');
1529:
1530: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 1622: , hr_all_organization_units_tl org

1618: END IF;
1619: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1620: SELECT org.organization_id, org.name
1621: FROM pji_org_denorm denorm
1622: , hr_all_organization_units_tl org
1623: WHERE
1624: denorm.organization_id = l_Top_Organization_ID
1625: AND org.organization_id = denorm.sub_organization_id
1626: AND org.language = USERENV('LANG');

Line 1642: , hr_all_organization_units_tl org

1638:
1639: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1640: SELECT org.organization_id, org.name
1641: FROM pji_org_denorm denorm
1642: , hr_all_organization_units_tl org
1643: , per_organization_list seclist
1644: WHERE
1645: denorm.organization_id = l_Top_Organization_ID
1646: AND org.organization_id = denorm.sub_organization_id

Line 1766: , hr_all_organization_units_tl org

1762: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1763: SELECT paimp.org_id
1764: , decode(p_View_By,'OU',org.name,'-1')
1765: FROM pa_implementations_all paimp
1766: , hr_all_organization_units_tl org
1767: WHERE 1=1
1768: AND org.language = USERENV('LANG')
1769: AND paimp.org_id = org.organization_id;
1770: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 1781: , hr_all_organization_units_tl org

1777: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1778: SELECT paimp.org_id
1779: , decode(p_View_By,'OU',org.name,'-1')
1780: FROM pa_implementations_all paimp
1781: , hr_all_organization_units_tl org
1782: , per_organization_list sec
1783: WHERE 1=1
1784: AND org.language = USERENV('LANG')
1785: AND sec.organization_id= paimp.org_id

Line 1804: FROM hr_all_organization_units_tl

1800: /*
1801: FORALL i IN 1..l_Dimension_List_Tab.Last
1802: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1803: SELECT organization_id, DECODE(p_View_BY,'OU',name,'-1')
1804: FROM hr_all_organization_units_tl
1805: WHERE
1806: organization_id=l_Dimension_List_Tab(i)
1807: AND language = USERENV('LANG');
1808: */

Line 1812: FROM hr_all_organization_units_tl

1808: */
1809: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
1810: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1811: SELECT organization_id, DECODE(p_View_BY,'OU',name,'-1')
1812: FROM hr_all_organization_units_tl
1813: WHERE
1814: organization_id=l_Dimension_List_Tab(i)
1815: AND language = USERENV('LANG');
1816: END LOOP;