APPS.QP_LIMITS_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 1224: FROM qp_segments_b a,qp_prc_contexts_b b

1220: UPDATE qp_pte_segments SET used_in_setup='Y'
1221: WHERE nvl(used_in_setup,'N')='N'
1222: AND segment_id IN
1223: (SELECT a.segment_id
1224: FROM qp_segments_b a,qp_prc_contexts_b b
1225: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute1
1226: AND a.prc_context_id=b.prc_context_id
1227: AND b.prc_context_type = p_LIMITS_rec.multival_attr1_type
1228: AND b.prc_context_code=p_LIMITS_rec.multival_attr1_context);

Line 1237: FROM qp_segments_b a,qp_prc_contexts_b b

1233: UPDATE qp_pte_segments SET used_in_setup='Y'
1234: WHERE nvl(used_in_setup,'N')='N'
1235: AND segment_id IN
1236: (SELECT a.segment_id
1237: FROM qp_segments_b a,qp_prc_contexts_b b
1238: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute2
1239: AND a.prc_context_id=b.prc_context_id
1240: AND b.prc_context_type = p_LIMITS_rec.multival_attr2_type
1241: AND b.prc_context_code=p_LIMITS_rec.multival_attr2_context);

Line 1405: FROM qp_segments_b a,qp_prc_contexts_b b

1401: UPDATE qp_pte_segments SET used_in_setup='Y'
1402: WHERE nvl(used_in_setup,'N')='N'
1403: AND segment_id IN
1404: (SELECT a.segment_id
1405: FROM qp_segments_b a,qp_prc_contexts_b b
1406: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute1
1407: AND a.prc_context_id=b.prc_context_id
1408: AND b.prc_context_type = p_LIMITS_rec.multival_attr1_type
1409: AND b.prc_context_code=p_LIMITS_rec.multival_attr1_context);

Line 1418: FROM qp_segments_b a,qp_prc_contexts_b b

1414: UPDATE qp_pte_segments SET used_in_setup='Y'
1415: WHERE nvl(used_in_setup,'N')='N'
1416: AND segment_id IN
1417: (SELECT a.segment_id
1418: FROM qp_segments_b a,qp_prc_contexts_b b
1419: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute2
1420: AND a.prc_context_id=b.prc_context_id
1421: AND b.prc_context_type = p_LIMITS_rec.multival_attr2_type
1422: AND b.prc_context_code=p_LIMITS_rec.multival_attr2_context);