APPS.QP_QUALIFIERS_UTIL dependencies on QP_SEGMENTS_B

Line 1178: FROM qp_segments_b a,qp_prc_contexts_b b

1174: UPDATE qp_pte_segments SET used_in_setup='Y'
1175: WHERE nvl(used_in_setup,'N')='N'
1176: AND segment_id IN
1177: (SELECT a.segment_id
1178: FROM qp_segments_b a,qp_prc_contexts_b b
1179: WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
1180: AND a.prc_context_id=b.prc_context_id
1181: AND b.prc_context_type='QUALIFIER'
1182: AND b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);

Line 1248: FROM qp_segments_b a,qp_prc_contexts_b b

1244:
1245:
1246: cursor update_pte_cur(l_qual_context varchar2,l_qual_attribute varchar2) is
1247: SELECT a.segment_id
1248: FROM qp_segments_b a,qp_prc_contexts_b b
1249: WHERE a.segment_mapping_column=l_qual_attribute
1250: AND a.prc_context_id=b.prc_context_id
1251: AND b.prc_context_type='QUALIFIER'
1252: AND b.prc_context_code=l_qual_context;

Line 1462: FROM qp_segments_b a,qp_prc_contexts_b b

1458: UPDATE qp_pte_segments SET used_in_setup='Y'
1459: WHERE nvl(used_in_setup,'N')='N'
1460: AND segment_id IN
1461: (SELECT a.segment_id
1462: FROM qp_segments_b a,qp_prc_contexts_b b
1463: WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
1464: AND a.prc_context_id=b.prc_context_id AND b.prc_context_type='QUALIFIER'
1465: AND b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);
1466: END IF;

Line 2002: FROM qp_segments_b a,qp_prc_contexts_b b

1998: UPDATE qp_pte_segments SET used_in_setup='N'
1999: WHERE
2000: segment_id IN
2001: (SELECT a.segment_id
2002: FROM qp_segments_b a,qp_prc_contexts_b b
2003: WHERE a.segment_mapping_column=l_qualifiers_rec.qualifier_attribute
2004: AND a.prc_context_id=b.prc_context_id
2005: AND b.prc_context_type='QUALIFIER'
2006: AND b.prc_context_code=l_qualifiers_rec.qualifier_context);