APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICES_ALL

Line 920: from AP_INVOICES_ALL AI,

916: l_inv_paid_flag VARCHAR2(1) := null;
917:
918: CURSOR l_po_inv_paid_csr IS
919: select NVL(AI.payment_status_flag, 'N')
920: from AP_INVOICES_ALL AI,
921: AP_INVOICE_DISTRIBUTIONS_ALL AID,
922: PO_DISTRIBUTIONS_ALL POD
923: where AI.invoice_id = AID.invoice_id
924: and AID.po_distribution_id = POD.po_distribution_id

Line 932: from AP_INVOICES_ALL AI,

928: and AID.reversal_flag <> 'Y'; ----Bug#11906141
929:
930: CURSOR l_rel_inv_paid_csr IS
931: select NVL(AI.payment_status_flag, 'N')
932: from AP_INVOICES_ALL AI,
933: AP_INVOICE_DISTRIBUTIONS_ALL AID,
934: PO_DISTRIBUTIONS_ALL POD
935: where AI.invoice_id = AID.invoice_id
936: and AID.po_distribution_id = POD.po_distribution_id

Line 1019: from AP_INVOICES_ALL AI,

1015:
1016: /*
1017: CURSOR l_inv_paid_csr IS
1018: select NVL(AI.payment_status_flag, 'N')
1019: from AP_INVOICES_ALL AI,
1020: AP_INVOICE_DISTRIBUTIONS_ALL AID,
1021: PO_DISTRIBUTIONS_ALL POD
1022: where AI.invoice_id = AID.invoice_id
1023: and AID.po_distribution_id = POD.po_distribution_id

Line 1028: from AP_INVOICES_ALL AI,

1024: and POD.line_location_id = p_line_location_id;
1025: */
1026: CURSOR l_inv_paid_csr IS
1027: select NVL(AI.payment_status_flag, 'N')
1028: from AP_INVOICES_ALL AI,
1029: AP_INVOICE_LINES_ALL AIL
1030: where AI.invoice_id = AIL.invoice_id
1031: and AIL.po_line_location_id = p_line_location_id;
1032: