APPS.AP_VOID_PKG dependencies on AP_INVOICE_RELATIONSHIPS

Line 174: ap_invoice_relationships air,

170: aid.income_tax_region income_tax_region
171: FROM ap_invoice_distributions aid,
172: gl_code_combinations gl,
173: ap_invoice_payments aip,
174: ap_invoice_relationships air,
175: ap_lookup_codes alc
176: WHERE air.related_invoice_id = aid.invoice_id
177: AND gl.code_combination_id = aid.dist_code_combination_id
178: AND aid.invoice_id = aip.invoice_id

Line 382: FROM ap_invoice_relationships air,

378: aps.gross_amount = 0,
379: aps.last_update_date = SYSDATE,
380: aps.amount_remaining = 0
381: WHERE aps.invoice_id IN (SELECT related_invoice_id
382: FROM ap_invoice_relationships air,
383: ap_invoice_payments_all aip
384: WHERE aip.check_id = P_Check_Id
385: AND air.related_invoice_id = aip.invoice_id
386: AND nvl(aip.reversal_flag, 'N') <> 'Y')

Line 412: FROM ap_invoice_relationships AIR,

408: AI.cancelled_date = sysdate, --bug5631957
409: AI.pay_curr_invoice_amount = 0 --bug5631957
410: WHERE AI.invoice_id IN
411: (SELECT AIR.related_invoice_id
412: FROM ap_invoice_relationships AIR,
413: ap_invoice_payments_all AIP
414: WHERE AIP.invoice_id = AIR.related_invoice_id
415: AND AIP.check_id = P_Check_Id
416: AND NVL(aip.reversal_flag, 'N') <> 'Y')

Line 439: FROM ap_invoice_relationships AIR,

435: AIL.amount = 0,
436: AIL.base_amount = 0
437: WHERE AIL.invoice_id IN
438: (SELECT AIR.related_invoice_id
439: FROM ap_invoice_relationships AIR,
440: ap_invoice_payments_all AIP
441: WHERE AIP.invoice_id = AIR.related_invoice_id
442: AND AIP.check_id = P_Check_Id
443: AND NVL(aip.reversal_flag, 'N') <> 'Y');

Line 452: ap_invoice_relationships air,

448: INTO l_max_dist_line_num
449: FROM ap_invoice_distributions aid,
450: gl_code_combinations gl,
451: ap_invoice_payments aip,
452: ap_invoice_relationships air,
453: ap_lookup_codes alc
454: WHERE air.related_invoice_id = aid.invoice_id
455: AND gl.code_combination_id = aid.dist_code_combination_id
456: AND aid.invoice_id = aip.invoice_id