DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_CLASS_CATEGORIES

Line 4173: FROM hz_class_categories cc, hz_code_assignments ca

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

Line 4285: FROM hz_class_categories cc, hz_code_assignments ca

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