APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 3044: FROM oe_order_price_attribs

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

Line 3084: FROM oe_order_price_attribs

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

Line 5418: FROM oe_order_price_attribs

5414: 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;
5415: Begin
5416:
5417: SELECT 1 into l_count
5418: FROM oe_order_price_attribs
5419: WHERE header_id = p_x_header_rec.header_id
5420: AND line_id = l_line_id
5421: AND orig_sys_atts_ref =
5422: p_x_line_price_att_tbl(I).orig_sys_atts_ref

Line 5465: FROM oe_order_price_attribs

5461: p_x_line_price_att_tbl(I).line_id := l_line_id;
5462:
5463: SELECT order_price_attrib_id
5464: INTO l_price_attrib_id
5465: FROM oe_order_price_attribs
5466: WHERE header_id = l_header_id
5467: AND line_id = l_line_id
5468: AND orig_sys_atts_ref =
5469: p_x_line_price_att_tbl(I).orig_sys_atts_ref;