APPS.AP_APXINHIS_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 243: AP_INVOICE_DISTRIBUTIONS AID1,

239: ,0))
240: INTO
241: PREPAY_AMT_F
242: FROM
243: AP_INVOICE_DISTRIBUTIONS AID1,
244: AP_INVOICE_DISTRIBUTIONS AID2,
245: AP_INVOICES I2
246: WHERE NVL(AID1.REVERSAL_FLAG
247: ,'N') <> 'Y'

Line 244: AP_INVOICE_DISTRIBUTIONS AID2,

240: INTO
241: PREPAY_AMT_F
242: FROM
243: AP_INVOICE_DISTRIBUTIONS AID1,
244: AP_INVOICE_DISTRIBUTIONS AID2,
245: AP_INVOICES I2
246: WHERE NVL(AID1.REVERSAL_FLAG
247: ,'N') <> 'Y'
248: AND AID1.PREPAY_DISTRIBUTION_ID is not null

Line 266: AP_INVOICE_DISTRIBUTIONS AID1,

262: ,0))
263: INTO
264: T_PREPAY_AMT_F
265: FROM
266: AP_INVOICE_DISTRIBUTIONS AID1,
267: AP_INVOICE_DISTRIBUTIONS AID2,
268: AP_INVOICES I2
269: WHERE NVL(AID1.REVERSAL_FLAG
270: ,'N') <> 'Y'

Line 267: AP_INVOICE_DISTRIBUTIONS AID2,

263: INTO
264: T_PREPAY_AMT_F
265: FROM
266: AP_INVOICE_DISTRIBUTIONS AID1,
267: AP_INVOICE_DISTRIBUTIONS AID2,
268: AP_INVOICES I2
269: WHERE NVL(AID1.REVERSAL_FLAG
270: ,'N') <> 'Y'
271: AND AID1.PREPAY_DISTRIBUTION_ID is not null

Line 289: AP_INVOICE_DISTRIBUTIONS AID1,

285: ,0))
286: INTO
287: T1_PREPAY_AMT_F
288: FROM
289: AP_INVOICE_DISTRIBUTIONS AID1,
290: AP_INVOICE_DISTRIBUTIONS AID2,
291: AP_INVOICES I2
292: WHERE NVL(AID1.REVERSAL_FLAG
293: ,'N') <> 'Y'

Line 290: AP_INVOICE_DISTRIBUTIONS AID2,

286: INTO
287: T1_PREPAY_AMT_F
288: FROM
289: AP_INVOICE_DISTRIBUTIONS AID1,
290: AP_INVOICE_DISTRIBUTIONS AID2,
291: AP_INVOICES I2
292: WHERE NVL(AID1.REVERSAL_FLAG
293: ,'N') <> 'Y'
294: AND AID1.PREPAY_DISTRIBUTION_ID is not null