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.PV_USER_RESP_PVT dependencies on JTF_LOC_HIERARCHIES_VL

Line 896: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh

892: AND delete_flag = 'N';
893:
894: CURSOR c_get_area1_resp (cv_user_role_code VARCHAR2) IS
895: SELECT rmr.resp_map_rule_id, rmr.responsibility_id
896: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh
897: WHERE rmr.user_role_code = p_user_role_code
898: AND rmr.program_id is null
899: AND rmr.geo_hierarchy_id = lh.location_hierarchy_id
900: AND lh.location_type_code = 'AREA1'

Line 1092: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh

1088: AND delete_flag = 'N';
1089:
1090: CURSOR c_get_area1_resp (cv_user_role_code VARCHAR2) IS
1091: SELECT rmr.resp_map_rule_id, rmr.responsibility_id
1092: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh
1093: WHERE rmr.user_role_code = p_user_role_code
1094: AND rmr.program_id is null
1095: AND rmr.geo_hierarchy_id = lh.location_hierarchy_id
1096: AND lh.location_type_code = 'AREA1'

Line 1287: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh

1283: AND delete_flag = 'N';
1284:
1285: CURSOR c_get_area1_resp (cv_user_role_code VARCHAR2, cv_program_id NUMBER) IS
1286: SELECT rmr.resp_map_rule_id, rmr.responsibility_id
1287: FROM pv_ge_resp_map_rules rmr, jtf_loc_hierarchies_vl lh
1288: WHERE rmr.user_role_code = p_user_role_code
1289: AND rmr.program_id = cv_program_id
1290: AND rmr.geo_hierarchy_id = lh.location_hierarchy_id
1291: AND lh.location_type_code = 'AREA1'