APPS.PJI_PMV_ENGINE dependencies on PJI_ORG_DENORM

Line 1242: FROM pji_org_denorm orgd,

1238: l_user_id := fnd_global.user_id;
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')

Line 1321: FROM pji_org_denorm orgd

1317: END IF;
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

Line 1341: FROM pji_org_denorm orgd

1337:
1338: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
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')

Line 1621: FROM pji_org_denorm denorm

1617: Write2FWKLog('Before insert of all sub-org organizations (w/o security)...');
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

Line 1641: FROM pji_org_denorm denorm

1637: IF l_sec_top_org_id IS NOT NULL THEN
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