APPS.JA_JAINITCL_XMLP_PKG dependencies on AP_INVOICE_LINES_ALL

Line 52: AP_INVOICE_LINES_ALL APLL

48: AP_INVOICE_PAYMENTS_ALL APIP,
49: PO_VENDORS POV1,
50: PO_VENDORS POV2,
51: PO_VENDOR_SITES_ALL POVS,
52: AP_INVOICE_LINES_ALL APLL
53: WHERE DECODE(AFRM.ORG_ID
54: ,NULL
55: ,0
56: ,AFRM.ORG_ID) = NVL(P_ORGANIZATION_ID

Line 89: AP_INVOICE_LINES_ALL

85: CURSOR FETCH_PREPAYMENT_AMT_CUR(CP_LINE_TYPE IN AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE) IS
86: SELECT
87: SUM(AMOUNT)
88: FROM
89: AP_INVOICE_LINES_ALL
90: WHERE INVOICE_ID = INVOICE_ID1
91: AND LINE_TYPE_LOOKUP_CODE = CP_LINE_TYPE;
92: V_PREPAYMENT_AMOUNT NUMBER;
93: BEGIN