DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on HZ_RELATIONSHIPS

Line 382: hz_relationships hzr1, hz_code_assignments hca

378: BEGIN
379: select distinct hz2.party_id
380: into l_party_id
381: from fnd_user f, hz_parties hz1, hz_parties hz2,
382: hz_relationships hzr1, hz_code_assignments hca
383: where f.person_party_id = hz1.party_id
384: and f.user_name = p_username
385: and hzr1.object_id = hz2.party_id
386: and hzr1.subject_id = hz1.party_id