APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 59: FROM zx_party_tax_profile ptp,

55: -- Populating the Establishment ID
56: BEGIN
57: SELECT xle_etb.establishment_id
58: INTO l_estb_id
59: FROM zx_party_tax_profile ptp,
60: xle_etb_profiles xle_etb,
61: ap_invoices_all ai
62: WHERE ai.invoice_id = p_upg_trx_info_rec.trx_id
63: AND ptp.party_id = xle_etb.party_id

Line 1020: zx_party_tax_profile ptp

1016: fnd_currencies fnd_curr,
1017: fnd_document_sequences fds,
1018: ap_invoice_lines_all lines,
1019: po_line_locations_all poll,
1020: zx_party_tax_profile ptp
1021: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
1022: AND fnd_curr.currency_code = inv.invoice_currency_code
1023: AND inv.doc_sequence_id = fds.doc_sequence_id(+)
1024: AND lines.invoice_id = inv.invoice_id

Line 2127: zx_party_tax_profile ptp

2123: zx_rates_b rates,
2124: zx_regimes_b regimes,
2125: zx_taxes_b taxes,
2126: zx_status_b status,
2127: zx_party_tax_profile ptp
2128: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
2129: AND fnd_curr.currency_code = inv.invoice_currency_code
2130: -- AND inv.doc_sequence_id = fds.doc_sequence_id(+)
2131: AND ap_dists.invoice_id = inv.invoice_id

Line 3187: zx_party_tax_profile ptp

3183: fnd_currencies fnd_curr,
3184: fnd_document_sequences fds,
3185: ap_invoice_lines_all lines,
3186: po_line_locations_all poll,
3187: zx_party_tax_profile ptp
3188: WHERE zxvalerr.other_doc_application_id = 200
3189: AND inv.invoice_id = zxvalerr.other_doc_trx_id
3190: AND fnd_curr.currency_code = inv.invoice_currency_code
3191: AND inv.doc_sequence_id = fds.doc_sequence_id(+)

Line 4271: zx_party_tax_profile ptp

4267: zx_rates_b rates,
4268: zx_regimes_b regimes,
4269: zx_taxes_b taxes,
4270: zx_status_b status,
4271: zx_party_tax_profile ptp
4272: WHERE zxvalerr.other_doc_application_id = 200
4273: AND inv.invoice_id = zxvalerr.other_doc_trx_id
4274: AND fnd_curr.currency_code = inv.invoice_currency_code
4275: -- AND inv.doc_sequence_id = fds.doc_sequence_id(+)