DBA Data[Home] [Help]

APPS.OE_OE_MULTI_LINE_SCREDIT dependencies on OE_SALES_CREDIT_TYPES

Line 128: OE_SALES_CREDIT_TYPES SCT

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

Line 135: OE_SALES_CREDIT_TYPES SCT

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