APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on AP_INVOICES

Line 1614: FROM ap_invoices ai,

1610: DECODE(NVL(ai.payment_status_flag, 'N'), 'N', 'IGC_PO_YEP_INV_NPAID',
1611: DECODE(NVL(aip.posted_flag, 'N'), 'N', 'IGC_PO_YEP_INV_PAY_NPOST',
1612: DECODE(SIGN(tmp.quantity_ordered - tmp.quantity_billed), -1,
1613: 'IGC_PO_YEP_PO_OVERBILLED')))) result_error_code
1614: FROM ap_invoices ai,
1615: ap_invoice_payments aip,
1616: ap_invoice_distributions aid,
1617: igc_cbc_po_process_gt tmp
1618: WHERE ai.invoice_id = aid.invoice_id

Line 1642: FROM ap_invoices ai,

1638: DECODE(NVL(ai.payment_status_flag, 'N'), 'N', 'IGC_PO_YEP_INV_NPAID',
1639: DECODE(NVL(aip.posted_flag, 'N'), 'N', 'IGC_PO_YEP_INV_PAY_NPOST',
1640: DECODE(SIGN(tmp.quantity_ordered - tmp.quantity_billed), -1,
1641: 'IGC_PO_YEP_REL_OVERBILLED')))) result_error_code
1642: FROM ap_invoices ai,
1643: ap_invoice_payments aip,
1644: ap_invoice_distributions aid,
1645: igc_cbc_po_process_gt tmp
1646: WHERE ai.invoice_id = aid.invoice_id