APPS.OE_OE_MULTI_HEADER_SCREDIT dependencies on OE_SALES_CREDITS

Line 143: FROM OE_SALES_CREDITS SC,

139: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
140:
141: Cursor C_OLD_R_SALES_CREDIT_ID(P_HEADER_ID Number) IS
142: SELECT Sales_Credit_ID
143: FROM OE_SALES_CREDITS SC,
144: OE_SALES_CREDIT_TYPES SCT
145: WHERE HEADER_ID = P_HEADER_ID
146: AND SCT.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID
147: AND SCT.QUOTA_FLAG = 'Y'

Line 151: FROM OE_SALES_CREDITS SC,

147: AND SCT.QUOTA_FLAG = 'Y'
148: AND LINE_ID IS NULL;
149: Cursor C_OLD_NR_SALES_CREDIT_ID(P_HEADER_ID Number) IS
150: SELECT Sales_Credit_ID
151: FROM OE_SALES_CREDITS SC,
152: OE_SALES_CREDIT_TYPES SCT
153: WHERE HEADER_ID = P_HEADER_ID
154: AND SCT.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID
155: AND SCT.QUOTA_FLAG = 'N'

Line 159: FROM OE_SALES_CREDITS

155: AND SCT.QUOTA_FLAG = 'N'
156: AND LINE_ID IS NULL;
157: Cursor C_OLD_SALES_CREDIT_ID(P_HEADER_ID Number) IS
158: SELECT Sales_Credit_ID
159: FROM OE_SALES_CREDITS
160: WHERE HEADER_ID = P_HEADER_ID
161: AND LINE_ID IS NULL;
162: I Number;
163: --serla begin