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 524: FROM ap_invoice_relationships air,

520: aps.gross_amount = 0,
521: aps.last_update_date = SYSDATE,
522: aps.amount_remaining = 0
523: WHERE aps.invoice_id IN (SELECT related_invoice_id
524: FROM ap_invoice_relationships air,
525: ap_invoice_payments_all aip
526: WHERE aip.check_id = P_Check_Id
527: AND air.related_invoice_id = aip.invoice_id
528: AND nvl(aip.reversal_flag, 'N') <> 'Y')

Line 557: FROM ap_invoice_relationships AIR,

553: AI.cancelled_date = sysdate, --bug5631957
554: AI.pay_curr_invoice_amount = 0 --bug5631957
555: WHERE AI.invoice_id IN
556: (SELECT AIR.related_invoice_id
557: FROM ap_invoice_relationships AIR,
558: ap_invoice_payments_all AIP
559: WHERE AIP.invoice_id = AIR.related_invoice_id
560: AND AIP.check_id = P_Check_Id
561: AND NVL(aip.reversal_flag, 'N') <> 'Y')

Line 587: FROM ap_invoice_relationships AIR,

583: AIL.amount = 0,
584: AIL.base_amount = 0
585: WHERE AIL.invoice_id IN
586: (SELECT AIR.related_invoice_id
587: FROM ap_invoice_relationships AIR,
588: ap_invoice_payments_all AIP
589: WHERE AIP.invoice_id = AIR.related_invoice_id
590: AND AIP.check_id = P_Check_Id
591: AND NVL(aip.reversal_flag, 'N') <> 'Y');

Line 603: ap_invoice_relationships air,

599: INTO l_max_dist_line_num
600: FROM ap_invoice_distributions aid,
601: gl_code_combinations gl,
602: ap_invoice_payments aip,
603: ap_invoice_relationships air,
604: ap_lookup_codes alc
605: WHERE air.related_invoice_id = aid.invoice_id
606: AND gl.code_combination_id = aid.dist_code_combination_id
607: AND aid.invoice_id = aip.invoice_id