APPS.QP_LIMIT_BALANCES_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 1100: FROM qp_segments_b a,qp_prc_contexts_b b

1096: UPDATE qp_pte_segments SET used_in_setup='Y'
1097: WHERE nvl(used_in_setup,'N')='N'
1098: AND segment_id IN
1099: (SELECT a.segment_id
1100: FROM qp_segments_b a,qp_prc_contexts_b b
1101: WHERE a.segment_mapping_column=p_LIMIT_BALANCES_rec.multival_attribute1
1102: AND a.prc_context_id=b.prc_context_id
1103: AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr1_type
1104: AND b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr1_context);

Line 1113: FROM qp_segments_b a,qp_prc_contexts_b b

1109: UPDATE qp_pte_segments SET used_in_setup='Y'
1110: WHERE nvl(used_in_setup,'N')='N'
1111: AND segment_id IN
1112: (SELECT a.segment_id
1113: FROM qp_segments_b a,qp_prc_contexts_b b
1114: WHERE a.segment_mapping_column=p_LIMIT_BALANCES_rec.multival_attribute2
1115: AND a.prc_context_id=b.prc_context_id
1116: AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr2_type
1117: AND b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr2_context);

Line 1252: FROM qp_segments_b a,qp_prc_contexts_b b

1248: UPDATE qp_pte_segments SET used_in_setup='Y'
1249: WHERE nvl(used_in_setup,'N')='N'
1250: AND segment_id IN
1251: (SELECT a.segment_id
1252: FROM qp_segments_b a,qp_prc_contexts_b b
1253: WHERE a.segment_mapping_column=p_LIMIT_BALANCES_rec.multival_attribute1
1254: AND a.prc_context_id=b.prc_context_id
1255: AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr1_type
1256: AND b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr1_context);

Line 1265: FROM qp_segments_b a,qp_prc_contexts_b b

1261: UPDATE qp_pte_segments SET used_in_setup='Y'
1262: WHERE nvl(used_in_setup,'N')='N'
1263: AND segment_id IN
1264: (SELECT a.segment_id
1265: FROM qp_segments_b a,qp_prc_contexts_b b
1266: WHERE a.segment_mapping_column=p_LIMIT_BALANCES_rec.multival_attribute2
1267: AND a.prc_context_id=b.prc_context_id
1268: AND b.prc_context_type = p_LIMIT_BALANCES_rec.multival_attr2_type
1269: AND b.prc_context_code=p_LIMIT_BALANCES_rec.multival_attr2_context);