DBA Data[Home] [Help]

APPS.OE_PRICING_CONT_PVT dependencies on QP_QUALIFIERS

Line 3139: delete from qp_qualifiers where

3135:
3136:
3137: if p_old_list_header_id <> p_list_header_id then
3138: oe_debug_pub.add('in else id!=id'||p_operation);
3139: delete from qp_qualifiers where
3140: list_header_id = p_old_list_header_id
3141: and qualifier_context = 'CUSTOMER'
3142: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE7'
3143: and qualifier_attr_value = p_agreement_id;

Line 3153: from qp_qualifiers where

3149: oe_debug_pub.add('in if id=id'||p_operation);
3150: BEGIN
3151:
3152: select count(list_header_id) into l_qual_count
3153: from qp_qualifiers where
3154: list_header_id = p_list_header_id
3155: and qualifier_context = 'CUSTOMER'
3156: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE7'
3157: and qualifier_attr_value = p_agreement_id;