APPS.OE_PRICE_LIST_LINE_UTIL dependencies on DUAL

Line 3193: FROM DUAL;

3189:
3190:
3191: SELECT QP_PRICING_ATTR_GROUP_NO_S.nextval
3192: INTO l_pricing_attr_grouping_no
3193: FROM DUAL;
3194:
3195: oe_debug_pub.add ( 'Geresh 18 :: Before Insert into Pricing attributes Maintain attributes ' );
3196:
3197: FOR I in 1..l_pricing_attr_tbl.count loop

Line 3201: from dual;

3197: FOR I in 1..l_pricing_attr_tbl.count loop
3198:
3199: SELECT QP_PRICING_ATTRIBUTES_S.nextval
3200: INTO l_pricing_attribute_id
3201: from dual;
3202:
3203: QP_PRICING_ATTRIBUTE_PVT.Insert_Row(
3204: X_PRICING_ATTRIBUTE_ID => l_pricing_attribute_id
3205: , X_CREATION_DATE => p_PRICE_LIST_LINE_rec.creation_date

Line 3254: from dual;

3250: IF p_PRICE_LIST_LINE_rec.price_break_parent_line is not null THEN
3251:
3252: select qp_rltd_modifier_grp_no_s.nextval
3253: into l_rltd_modifier_grp_no
3254: from dual;
3255: oe_debug_pub.add ( 'Geresh 30 :: Before Insert into Pricing attributes Maintain attributes ' );
3256:
3257: select qp_rltd_modifiers_s.nextval
3258: into l_related_modifier_id

Line 3259: from dual;

3255: oe_debug_pub.add ( 'Geresh 30 :: Before Insert into Pricing attributes Maintain attributes ' );
3256:
3257: select qp_rltd_modifiers_s.nextval
3258: into l_related_modifier_id
3259: from dual;
3260: oe_debug_pub.add ( 'Geresh 31 :: ' || p_PRICE_LIST_LINE_rec.price_break_parent_line );
3261: oe_debug_pub.add ( 'Geresh 31:: 1 ' || p_PRICE_LIST_LINE_rec.price_list_line_id );
3262:
3263: /*