DBA Data[Home] [Help]

APPS.ZX_API_PRVDR_PUB dependencies on HZ_PARTIES

Line 43: FROM HZ_PARTIES pty,

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')

Line 499: FROM HZ_PARTIES pty,

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')