39: BEGIN
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')
495: BEGIN
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')