DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on HRI_CS_ORGHRO_V

Line 1469: FROM hri_cs_orghro_v orgd

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

Line 1493: FROM hri_cs_orghro_v orgd

1489:
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