DBA Data[Home] [Help]

APPS.ZX_API_PRVDR_PUB dependencies on ZX_PARTY_TAX_PROFILE

Line 44: ZX_PARTY_TAX_PROFILE ptp

40: IF p_srvc_prvdr_name is not null THEN
41: SELECT ptp.party_tax_profile_id
42: INTO x_api_owner_id
43: FROM HZ_PARTIES pty,
44: ZX_PARTY_TAX_PROFILE ptp
45: WHERE pty.party_name = p_srvc_prvdr_name
46: AND pty.party_id = ptp.party_id
47: AND ptp.provider_type_code in ('BOTH', 'SERVICE')
48: AND (ptp.party_tax_profile_id =1

Line 500: ZX_PARTY_TAX_PROFILE ptp

496: IF p_srvc_prvdr_name is not null THEN
497: SELECT ptp.party_tax_profile_id
498: INTO l_api_owner_id
499: FROM HZ_PARTIES pty,
500: ZX_PARTY_TAX_PROFILE ptp
501: WHERE pty.party_name = p_srvc_prvdr_name
502: AND pty.party_id = ptp.party_id
503: AND ptp.provider_type_code in ('BOTH', 'SERVICE')
504: AND (ptp.party_tax_profile_id =1