APPS.PV_USER_RESP_PVT dependencies on PV_GE_RESP_MAP_RULES

Line 889: FROM pv_ge_resp_map_rules

885: )
886: IS
887: CURSOR c_get_resp_map_rule_info (cv_user_role_code VARCHAR2) IS
888: SELECT resp_map_rule_id, geo_hierarchy_id, responsibility_id
889: FROM pv_ge_resp_map_rules
890: WHERE user_role_code = p_user_role_code
891: AND program_id is null
892: AND delete_flag = 'N';
893:

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 1085: FROM pv_ge_resp_map_rules

1081: )
1082: IS
1083: CURSOR c_get_resp_map_rule_info (cv_user_role_code VARCHAR2) IS
1084: SELECT resp_map_rule_id, geo_hierarchy_id, responsibility_id
1085: FROM pv_ge_resp_map_rules
1086: WHERE user_role_code = cv_user_role_code
1087: AND program_id is null
1088: AND delete_flag = 'N';
1089:

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 1280: FROM pv_ge_resp_map_rules

1276: )
1277: IS
1278: CURSOR c_get_resp_map_rule_info (cv_user_role_code VARCHAR2, cv_program_id NUMBER) IS
1279: SELECT resp_map_rule_id, geo_hierarchy_id, responsibility_id
1280: FROM pv_ge_resp_map_rules
1281: WHERE user_role_code = cv_user_role_code
1282: AND program_id = cv_program_id
1283: AND delete_flag = 'N';
1284:

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'

Line 4300: FROM pv_ge_resp_map_rules

4296: ORDER BY partner_id, user_role_code;
4297:
4298: CURSOR c_get_new_resp (cv_source_resp_map_rule_id NUMBER) IS
4299: SELECT responsibility_id
4300: FROM pv_ge_resp_map_rules
4301: WHERE resp_map_rule_id = cv_source_resp_map_rule_id;
4302:
4303: CURSOR c_get_count (cv_partner_id NUMBER, cv_user_role_code VARCHAR2, cv_responsibility_id NUMBER) IS
4304: SELECT count(*)

Line 4530: FROM pv_pg_memberships m, pv_ge_resp_map_rules mr

4526: )
4527: IS
4528: CURSOR c_get_resp_info_1 (cv_source_resp_map_rule_id NUMBER) IS
4529: SELECT m.partner_id, mr.user_role_code, mr.program_id
4530: FROM pv_pg_memberships m, pv_ge_resp_map_rules mr
4531: WHERE mr.program_id = m.program_id
4532: AND m.membership_status_code = 'ACTIVE'
4533: AND mr.resp_map_rule_id = cv_source_resp_map_rule_id;
4534:

Line 4537: FROM pv_ge_resp_map_rules mr

4533: AND mr.resp_map_rule_id = cv_source_resp_map_rule_id;
4534:
4535: CURSOR c_get_resp_info_2 (cv_source_resp_map_rule_id NUMBER) IS
4536: SELECT user_role_code
4537: FROM pv_ge_resp_map_rules mr
4538: WHERE program_id is null
4539: AND resp_map_rule_id = cv_source_resp_map_rule_id;
4540:
4541: CURSOR c_get_ptnr_resps_1 (cv_partner_id NUMBER, cv_user_role_code VARCHAR2, cv_program_id NUMBER) IS