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';
132: Cursor C_OLD_NR_SALES_CREDIT_ID(P_Line_ID Number) IS
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';
139: Cursor C_OLD_SALES_CREDIT_ID(P_Line_ID Number) IS