DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on HZ_PARTIES

Line 2718: hz_parties HZP,

2714: NVL(AI.invoice_amount, 0) invoice_amount,
2715: AI.invoice_currency_code
2716: FROM
2717: ap_invoices_all AI,
2718: hz_parties HZP,
2719: hz_party_sites HZPS
2720: WHERE
2721: AI.invoice_id = l_invoice_id AND
2722: AI.party_id = HZP.party_id AND

Line 5893: hz_parties HZP

5889: AI.org_id,
5890: AI.invoice_id,
5891: NVL(AI.invoice_amount, 0)
5892: FROM ap_invoices_all AI,
5893: hz_parties HZP
5894: WHERE AI.invoice_id = p_invoice_id
5895: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5896: AND AI.party_id = HZP.party_id;
5897: