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.PJI_PMV_ENGINE dependencies on PER_ORGANIZATION_LIST

Line 1342: , per_organization_list sec

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')
1346: AND sec.security_profile_id = l_Security_Profile_ID

Line 1495: , per_organization_list sec

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
1499: AND sec.security_profile_id = l_Security_Profile_ID

Line 1643: , per_organization_list seclist

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
1647: AND seclist.security_profile_id = l_Security_Profile_ID

Line 1782: , per_organization_list sec

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
1786: AND sec.security_profile_id = l_Security_Profile_ID