DBA Data[Home] [Help]

APPS.JA_JAINSTAC_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 7: LV_PREPAYMENT AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

3: FUNCTION BALANCE(DT1 IN DATE
4: ,DT2 IN DATE
5: ,VEND_ID IN NUMBER) RETURN NUMBER IS
6: V_AMOUNT NUMBER;
7: LV_PREPAYMENT AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
8: BEGIN
9: LV_PREPAYMENT := 'PREPAYMENT';
10: SELECT
11: SUM((API.INVOICE_AMOUNT - NVL(AMOUNT_PAID

Line 16: AP_INVOICES_ALL API

12: ,0)) * NVL(EXCHANGE_RATE
13: ,1)) AMOUNT
14: INTO V_AMOUNT
15: FROM
16: AP_INVOICES_ALL API
17: WHERE API.VENDOR_ID = VEND_ID
18: AND TRUNC(API.INVOICE_DATE) BETWEEN TRUNC(DT1)
19: AND TRUNC(DT2)
20: AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )

Line 38: AP_INVOICES_ALL API

34: ,0)) * NVL(EXCHANGE_RATE
35: ,1)) AMOUNT
36: INTO V_AMOUNT
37: FROM
38: AP_INVOICES_ALL API
39: WHERE API.VENDOR_ID = VEND_ID
40: AND TRUNC(API.INVOICE_DATE) < TRUNC(DT)
41: AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )
42: AND API.INVOICE_TYPE_LOOKUP_CODE <> 'PREPAYMENT'