DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_CLASS_CATEGORIES

Line 4171: FROM hz_class_categories cc, hz_code_assignments ca

4167: WHERE code_assignment_id = p_from_id;
4168:
4169: CURSOR check_multiple_assignments IS
4170: SELECT 'Y'
4171: FROM hz_class_categories cc, hz_code_assignments ca
4172: WHERE ca.owner_table_id = p_to_fk_id
4173: AND cc.class_category = ca.class_category
4174: AND cc.allow_multi_assign_flag = 'N'
4175: AND ca.class_category = l_class_category;

Line 4283: FROM hz_class_categories cc, hz_code_assignments ca

4279: WHERE code_assignment_id = p_from_id;
4280:
4281: CURSOR check_multiple_assignments IS
4282: SELECT 'Y'
4283: FROM hz_class_categories cc, hz_code_assignments ca
4284: WHERE ca.owner_table_id = p_to_fk_id
4285: AND cc.class_category = ca.class_category
4286: AND cc.allow_multi_assign_flag = 'N'
4287: AND ca.class_category = l_class_category;