APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_SALES_CREDITS

Line 3234: FROM oe_sales_credits

3230: oe_debug_pub.add( 'NEW SCREDITS FOR THE EXISITNG HEARDER_ID:' || TO_CHAR ( P_X_HEADER_SCREDIT_TBL ( I ) .HEADER_ID ) ) ;
3231: END IF;
3232:
3233: SELECT 1 into l_count
3234: FROM oe_sales_credits
3235: WHERE header_id = p_x_header_rec.header_id
3236: AND line_id IS NULL
3237: AND orig_sys_credit_ref =
3238: p_x_header_scredit_tbl(I).orig_sys_credit_ref

Line 3276: FROM oe_sales_credits

3272: oe_debug_pub.add( 'SCREDIT REF: '||P_X_HEADER_SCREDIT_TBL ( I ) .ORIG_SYS_CREDIT_REF ) ;
3273: END IF;
3274: SELECT sales_credit_id
3275: INTO l_sales_credit_id
3276: FROM oe_sales_credits
3277: WHERE header_id = l_header_id
3278: AND line_id IS NULL
3279: AND orig_sys_credit_ref =
3280: p_x_header_scredit_tbl(I).orig_sys_credit_ref;

Line 5617: FROM oe_sales_credits

5613: p_x_line_scredit_tbl(I).header_id := l_header_id;
5614: p_x_line_scredit_tbl(I).line_id := l_line_id;
5615:
5616: SELECT 1 into l_count
5617: FROM oe_sales_credits
5618: WHERE header_id = p_x_header_rec.header_id
5619: AND line_id = l_line_id
5620: AND orig_sys_credit_ref =
5621: p_x_line_scredit_tbl(I).orig_sys_credit_ref

Line 5663: FROM oe_sales_credits

5659: p_x_line_scredit_tbl(I).header_id := l_header_id;
5660: p_x_line_scredit_tbl(I).line_id := l_line_id;
5661: SELECT sales_credit_id
5662: INTO l_sales_credit_id
5663: FROM oe_sales_credits
5664: WHERE header_id = p_x_header_rec.header_id
5665: AND line_id = l_line_id
5666: AND orig_sys_credit_ref =
5667: p_x_line_scredit_tbl(I).orig_sys_credit_ref;