APPS.OE_OE_MULTI_HEADER_SCREDIT dependencies on OE_SALES_CREDIT_TYPES

Line 144: OE_SALES_CREDIT_TYPES SCT

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'
148: AND LINE_ID IS NULL;

Line 152: OE_SALES_CREDIT_TYPES SCT

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'
156: AND LINE_ID IS NULL;