APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_SALES_CREDITS

Line 3237: FROM oe_sales_credits

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

Line 3279: FROM oe_sales_credits

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

Line 5684: FROM oe_sales_credits

5680: p_x_line_scredit_tbl(I).header_id := l_header_id;
5681: p_x_line_scredit_tbl(I).line_id := l_line_id;
5682:
5683: SELECT 1 into l_count
5684: FROM oe_sales_credits
5685: WHERE header_id = p_x_header_rec.header_id
5686: AND line_id = l_line_id
5687: AND orig_sys_credit_ref =
5688: p_x_line_scredit_tbl(I).orig_sys_credit_ref

Line 5730: FROM oe_sales_credits

5726: p_x_line_scredit_tbl(I).header_id := l_header_id;
5727: p_x_line_scredit_tbl(I).line_id := l_line_id;
5728: SELECT sales_credit_id
5729: INTO l_sales_credit_id
5730: FROM oe_sales_credits
5731: WHERE header_id = p_x_header_rec.header_id
5732: AND line_id = l_line_id
5733: AND orig_sys_credit_ref =
5734: p_x_line_scredit_tbl(I).orig_sys_credit_ref;