APPS.OE_OE_MULTI_LINE_SCREDIT dependencies on OE_SALES_CREDITS

Line 127: FROM OE_SALES_CREDITS SC,

123:
124:
125: Cursor C_OLD_R_SALES_CREDIT_ID(P_Line_ID Number) IS
126: SELECT Sales_Credit_ID
127: FROM OE_SALES_CREDITS SC,
128: OE_SALES_CREDIT_TYPES SCT
129: WHERE Line_ID = P_Line_ID
130: AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
131: AND sct.QUOTA_FLAG = 'Y';

Line 134: FROM OE_SALES_CREDITS SC,

130: AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
131: AND sct.QUOTA_FLAG = 'Y';
132: Cursor C_OLD_NR_SALES_CREDIT_ID(P_Line_ID Number) IS
133: SELECT Sales_Credit_ID
134: FROM OE_SALES_CREDITS SC,
135: OE_SALES_CREDIT_TYPES SCT
136: WHERE Line_ID = P_Line_ID
137: AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
138: AND SCT.QUOTA_FLAG = 'N';

Line 141: FROM OE_SALES_CREDITS

137: AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
138: AND SCT.QUOTA_FLAG = 'N';
139: Cursor C_OLD_SALES_CREDIT_ID(P_Line_ID Number) IS
140: SELECT Sales_Credit_ID
141: FROM OE_SALES_CREDITS
142: WHERE Line_ID = P_Line_ID;
143: I Number;
144: --serla begin
145: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;