APPS.PN_R12_UTIL_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 498: FROM zx_party_tax_profile zpt,

494: RETURN VARCHAR2 IS
495:
496: CURSOR get_flag_value IS
497: SELECT DECODE( NVL(inclusive_tax_flag,'Y'),'Y','S','N') tax_flag
498: FROM zx_party_tax_profile zpt,
499: po_vendors pov
500: WHERE pov.vendor_id = p_vendor_id
501: AND zpt.party_id = pov.party_id
502: AND party_type_code = 'THIRD_PARTY';

Line 507: FROM zx_party_tax_profile zpt,

503:
504: -- Added for Bug #6413109
505: CURSOR get_site_flag_value IS
506: SELECT DECODE( NVL(inclusive_tax_flag,'Y'),'Y','S','N') tax_flag
507: FROM zx_party_tax_profile zpt,
508: po_vendor_sites_all pvsa
509: WHERE pvsa.VENDOR_SITE_ID = p_vendor_site_id
510: AND zpt.party_id = pvsa.party_site_id
511: AND party_type_code = 'THIRD_PARTY_SITE';