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_UTIL dependencies on PER_ORGANIZATION_LIST

Line 1051: , per_organization_list sec

1047: BULK COLLECT INTO l_Organization_List
1048: FROM
1049: per_org_structure_elements orgd
1050: , pji_system_settings pset
1051: , per_organization_list sec
1052: , hr_all_organization_units_tl org
1053: WHERE 1=1
1054: AND orgd.org_structure_version_id = pset.org_structure_version_id
1055: AND orgd.organization_id_child = org.organization_id

Line 1106: , per_organization_list sec

1102: (select 1 from
1103: per_org_structure_elements c
1104: where c.organization_id_child = p.organization_id_parent
1105: and c.org_structure_version_id = p.org_structure_version_id)) orgd
1106: , per_organization_list sec
1107: , hr_all_organization_units_tl org
1108: , per_security_profiles prof
1109: WHERE 1=1
1110: AND orgd.organization_id_child = org.organization_id

Line 1187: , per_organization_list sec

1183: (SELECT orgd.organization_id_child
1184: FROM
1185: per_org_structure_elements orgd
1186: , pji_system_settings pset
1187: , per_organization_list sec
1188: , hr_all_organization_units org
1189: WHERE 1=1
1190: AND orgd.org_structure_version_id = pset.org_structure_version_id
1191: AND orgd.organization_id_child = org.organization_id

Line 1238: , per_organization_list sec

1234: (select 1 from
1235: per_org_structure_elements c
1236: where c.organization_id_child = p.organization_id_parent
1237: and c.org_structure_version_id = p.org_structure_version_id)) orgd
1238: , per_organization_list sec
1239: , hr_all_organization_units org
1240: , per_security_profiles prof
1241: WHERE 1=1
1242: AND orgd.organization_id_child = org.organization_id