DBA Data[Home] [Help]

APPS.POS_ENTERPRISE_UTIL_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 13: FROM hz_parties hp, hz_code_assignments hca

9: )
10: IS
11: CURSOR l_cur IS
12: SELECT hp.party_id, hp.party_name
13: FROM hz_parties hp, hz_code_assignments hca
14: WHERE hca.owner_table_id = hp.party_id
15: AND hca.owner_table_name = 'HZ_PARTIES'
16: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
17: AND hca.class_code = 'ENTERPRISE'

Line 80: FROM hz_parties hp, hz_code_assignments hca

76: )
77: IS
78: CURSOR l_cur IS
79: SELECT hp.party_id, hp.party_name
80: FROM hz_parties hp, hz_code_assignments hca
81: WHERE hca.owner_table_id = hp.party_id
82: AND hca.owner_table_name = 'HZ_PARTIES'
83: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
84: AND hca.class_code = 'ENTERPRISE'