APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CODE_ASSIGNMENTS

Line 1100: FROM HZ_CODE_ASSIGNMENTS

1096:
1097: CURSOR dupcheck IS
1098: SELECT
1099: CODE_ASSIGNMENT_ID
1100: FROM HZ_CODE_ASSIGNMENTS
1101: WHERE owner_table_name = p_owner_table_name
1102: AND owner_table_id = p_to_fk_id
1103: --AND (status IS NULL OR status = 'A')--Commented for Bug#3016319.
1104: AND CLASS_CATEGORY || CLASS_CODE = (

Line 1107: FROM HZ_CODE_ASSIGNMENTS

1103: --AND (status IS NULL OR status = 'A')--Commented for Bug#3016319.
1104: AND CLASS_CATEGORY || CLASS_CODE = (
1105: SELECT CLASS_CATEGORY ||
1106: CLASS_CODE
1107: FROM HZ_CODE_ASSIGNMENTS
1108: WHERE code_assignment_id = p_from_id);
1109:
1110: CURSOR c_cont_source IS
1111: SELECT CONTENT_SOURCE_TYPE

Line 1112: FROM HZ_CODE_ASSIGNMENTS

1108: WHERE code_assignment_id = p_from_id);
1109:
1110: CURSOR c_cont_source IS
1111: SELECT CONTENT_SOURCE_TYPE
1112: FROM HZ_CODE_ASSIGNMENTS
1113: WHERE code_assignment_id = p_from_id;
1114:
1115: l_cont_source VARCHAR2(255);
1116: l_record_id NUMBER;