DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on OE_AGREEMENTS_VL

Line 208: FROM OE_AGREEMENTS_VL

204:
205: /* Code change for Quoting Usability Sun ER Start */
206: CURSOR C_AGREEMENT(P_AGREEMENT_ID IN NUMBER,P_INVOICE_TO_CUSTOMER_ID IN NUMBER) IS
207: SELECT 'x'
208: FROM OE_AGREEMENTS_VL
209: WHERE AGREEMENT_ID = P_AGREEMENT_ID
210: AND INVOICE_TO_CUSTOMER_ID = P_INVOICE_TO_CUSTOMER_ID;
211:
212: l_var varchar2(1);

Line 2531: FROM OE_AGREEMENTS_VL

2527: l_return_value Varchar2(1);
2528:
2529: CURSOR C_AGREEMENT(P_AGREEMENT_ID IN NUMBER,P_INVOICE_TO_CUSTOMER_ID IN NUMBER) IS
2530: SELECT 'x'
2531: FROM OE_AGREEMENTS_VL
2532: WHERE AGREEMENT_ID = P_AGREEMENT_ID
2533: AND INVOICE_TO_CUSTOMER_ID = P_INVOICE_TO_CUSTOMER_ID;
2534:
2535: l_var varchar2(1);