APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICES_ALL

Line 883: from AP_INVOICES_ALL AI,

879: l_inv_paid_flag VARCHAR2(1) := null;
880:
881: CURSOR l_po_inv_paid_csr IS
882: select NVL(AI.payment_status_flag, 'N')
883: from AP_INVOICES_ALL AI,
884: AP_INVOICE_DISTRIBUTIONS_ALL AID,
885: PO_DISTRIBUTIONS_ALL POD
886: where AI.invoice_id = AID.invoice_id
887: and AID.po_distribution_id = POD.po_distribution_id

Line 893: from AP_INVOICES_ALL AI,

889: and POD.po_release_id is null;
890:
891: CURSOR l_rel_inv_paid_csr IS
892: select NVL(AI.payment_status_flag, 'N')
893: from AP_INVOICES_ALL AI,
894: AP_INVOICE_DISTRIBUTIONS_ALL AID,
895: PO_DISTRIBUTIONS_ALL POD
896: where AI.invoice_id = AID.invoice_id
897: and AID.po_distribution_id = POD.po_distribution_id

Line 978: from AP_INVOICES_ALL AI,

974:
975: /*
976: CURSOR l_inv_paid_csr IS
977: select NVL(AI.payment_status_flag, 'N')
978: from AP_INVOICES_ALL AI,
979: AP_INVOICE_DISTRIBUTIONS_ALL AID,
980: PO_DISTRIBUTIONS_ALL POD
981: where AI.invoice_id = AID.invoice_id
982: and AID.po_distribution_id = POD.po_distribution_id

Line 987: from AP_INVOICES_ALL AI,

983: and POD.line_location_id = p_line_location_id;
984: */
985: CURSOR l_inv_paid_csr IS
986: select NVL(AI.payment_status_flag, 'N')
987: from AP_INVOICES_ALL AI,
988: AP_INVOICE_LINES_ALL AIL
989: where AI.invoice_id = AIL.invoice_id
990: and AIL.po_line_location_id = p_line_location_id;
991: