DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on HZ_PARTIES

Line 2620: hz_parties HZP,

2616: NVL(AI.invoice_amount, 0) invoice_amount,
2617: AI.invoice_currency_code
2618: FROM
2619: ap_invoices_all AI,
2620: hz_parties HZP,
2621: hz_party_sites HZPS
2622: WHERE
2623: AI.invoice_id = l_invoice_id AND
2624: AI.party_id = HZP.party_id AND

Line 5652: hz_parties HZP

5648: AI.org_id,
5649: AI.invoice_id,
5650: NVL(AI.invoice_amount, 0)
5651: FROM ap_invoices_all AI,
5652: hz_parties HZP
5653: WHERE AI.invoice_id = p_invoice_id
5654: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5655: AND AI.party_id = HZP.party_id;
5656: