APPS.QP_LIMITS_UTIL dependencies on QP_SEGMENTS_B

Line 1255: FROM qp_segments_b a,qp_prc_contexts_b b

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

Line 1268: FROM qp_segments_b a,qp_prc_contexts_b b

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

Line 1436: FROM qp_segments_b a,qp_prc_contexts_b b

1432: UPDATE qp_pte_segments SET used_in_setup='Y'
1433: WHERE nvl(used_in_setup,'N')='N'
1434: AND segment_id IN
1435: (SELECT a.segment_id
1436: FROM qp_segments_b a,qp_prc_contexts_b b
1437: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute1
1438: AND a.prc_context_id=b.prc_context_id
1439: AND b.prc_context_type = p_LIMITS_rec.multival_attr1_type
1440: AND b.prc_context_code=p_LIMITS_rec.multival_attr1_context);

Line 1449: FROM qp_segments_b a,qp_prc_contexts_b b

1445: UPDATE qp_pte_segments SET used_in_setup='Y'
1446: WHERE nvl(used_in_setup,'N')='N'
1447: AND segment_id IN
1448: (SELECT a.segment_id
1449: FROM qp_segments_b a,qp_prc_contexts_b b
1450: WHERE a.segment_mapping_column=p_LIMITS_rec.multival_attribute2
1451: AND a.prc_context_id=b.prc_context_id
1452: AND b.prc_context_type = p_LIMITS_rec.multival_attr2_type
1453: AND b.prc_context_code=p_LIMITS_rec.multival_attr2_context);