APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 3047: FROM oe_order_price_attribs

3043: p_x_header_price_att_tbl(I).header_id := l_header_id;
3044: Begin
3045:
3046: SELECT 1 into l_count
3047: FROM oe_order_price_attribs
3048: WHERE header_id = p_x_header_rec.header_id
3049: AND line_id IS NULL
3050: AND orig_sys_atts_ref =
3051: p_x_header_price_att_tbl(I).orig_sys_atts_ref

Line 3087: FROM oe_order_price_attribs

3083: oe_debug_pub.add( 'ATTRIBUTE REF: '||P_X_HEADER_PRICE_ATT_TBL ( I ) .ORIG_SYS_ATTS_REF ) ;
3084: END IF;
3085: SELECT order_price_attrib_id
3086: INTO l_price_attrib_id
3087: FROM oe_order_price_attribs
3088: WHERE header_id = p_x_header_rec.header_id
3089: AND line_id IS NULL
3090: AND orig_sys_atts_ref =
3091: p_x_header_price_att_tbl(I).orig_sys_atts_ref;

Line 5485: FROM oe_order_price_attribs

5481: p_x_line_price_att_tbl(I).line_id := p_x_line_tbl(p_x_line_price_att_tbl(I).line_index).line_id; --l_line_id;
5482: Begin
5483:
5484: SELECT 1 into l_count
5485: FROM oe_order_price_attribs
5486: WHERE header_id = p_x_header_rec.header_id
5487: AND line_id = l_line_id
5488: AND orig_sys_atts_ref =
5489: p_x_line_price_att_tbl(I).orig_sys_atts_ref

Line 5532: FROM oe_order_price_attribs

5528: p_x_line_price_att_tbl(I).line_id := l_line_id;
5529:
5530: SELECT order_price_attrib_id
5531: INTO l_price_attrib_id
5532: FROM oe_order_price_attribs
5533: WHERE header_id = l_header_id
5534: AND line_id = l_line_id
5535: AND orig_sys_atts_ref =
5536: p_x_line_price_att_tbl(I).orig_sys_atts_ref;