APPS.JA_JAINITCP_XMLP_PKG dependencies on AP_INVOICE_LINES_ALL

Line 58: AP_INVOICE_LINES_ALL APLA

54: PO_VENDORS POV1,
55: PO_VENDORS POV2,
56: PO_VENDORS POV3,
57: PO_VENDOR_SITES_ALL POVS,
58: AP_INVOICE_LINES_ALL APLA
59: WHERE DECODE(AFRM.ORG_ID
60: ,NULL
61: ,0
62: ,AFRM.ORG_ID) = NVL(P_ORGANIZATION_ID

Line 96: AP_INVOICE_LINES_ALL

92: CURSOR FETCH_PREPAYMENT_AMT_CUR IS
93: SELECT
94: SUM(AMOUNT)
95: FROM
96: AP_INVOICE_LINES_ALL
97: WHERE INVOICE_ID = INVOICE_ID_V
98: AND LINE_TYPE_LOOKUP_CODE = 'PREPAY';
99: V_PREPAYMENT_AMOUNT NUMBER;
100: BEGIN

Line 234: AP_INVOICE_LINES_ALL

230: CURSOR C_ACCTD_DATE IS
231: SELECT
232: ACCOUNTING_DATE
233: FROM
234: AP_INVOICE_LINES_ALL
235: WHERE INVOICE_ID = INVOICE_ID_V
236: AND LINE_NUMBER = 1;
237: V_ACCTD_DATE DATE;
238: BEGIN