DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on OE_AGREEMENTS_B

Line 293: FROM OE_AGREEMENTS_B

289: IS
290:
291: CURSOR C_Get_PL (l_agreement_id NUMBER) IS
292: SELECT Price_List_Id
293: FROM OE_AGREEMENTS_B
294: WHERE Agreement_Id = l_agreement_id
295: AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);
296:
297: l_agreement_id NUMBER;

Line 535: FROM OE_AGREEMENTS_B

531: IS
532:
533: CURSOR C_Get_PayTerm (l_agreement_id NUMBER) IS
534: SELECT Term_Id
535: FROM OE_AGREEMENTS_B
536: WHERE Agreement_Id = l_agreement_id
537: AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);
538:
539: l_agreement_id NUMBER;