DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 23: FROM hz_code_assignments

19: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;
20:
21: CURSOR l_cur IS
22: SELECT code_assignment_id
23: FROM hz_code_assignments
24: WHERE owner_table_name = 'HZ_PARTIES'
25: AND owner_table_id = p_party_id
26: AND class_category = p_category
27: AND class_code = p_code

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