APPS.HZ_PARTY_MERGE dependencies on HZ_CODE_ASSIGNMENTS

Line 4033: -- Handle DNB data in HZ_CODE_ASSIGNMENTS

4029: END;
4030: END LOOP;
4031:
4032: -- *******************************************
4033: -- Handle DNB data in HZ_CODE_ASSIGNMENTS
4034: FOR FROM_CA IN (
4035: SELECT code_assignment_id, class_category, class_code
4036: FROM HZ_CODE_ASSIGNMENTS
4037: WHERE owner_table_name = 'HZ_PARTIES'

Line 4036: FROM HZ_CODE_ASSIGNMENTS

4032: -- *******************************************
4033: -- Handle DNB data in HZ_CODE_ASSIGNMENTS
4034: FOR FROM_CA IN (
4035: SELECT code_assignment_id, class_category, class_code
4036: FROM HZ_CODE_ASSIGNMENTS
4037: WHERE owner_table_name = 'HZ_PARTIES'
4038: AND content_source_type = 'DNB'
4039: AND nvl(status, 'A') = 'A'
4040: AND owner_table_id = p_from_id) LOOP

Line 4044: FROM HZ_CODE_ASSIGNMENTS

4040: AND owner_table_id = p_from_id) LOOP
4041:
4042: BEGIN
4043: SELECT code_assignment_id INTO l_to
4044: FROM HZ_CODE_ASSIGNMENTS
4045: WHERE owner_table_name = 'HZ_PARTIES'
4046: AND content_source_type = 'DNB'
4047: AND nvl(status, 'A') = 'A'
4048: AND owner_table_id = x_to_id

Line 4058: 'HZ_CODE_ASSIGNMENTS',

4054: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4055: -- Merge to into from
4056: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4057: p_batch_party_id,
4058: 'HZ_CODE_ASSIGNMENTS',
4059: FROM_CA.code_assignment_id,
4060: l_to,
4061: 'Y',
4062: hz_utility_pub.created_by,

Line 4071: 'HZ_CODE_ASSIGNMENTS',

4067: ELSE -- To Newer
4068: -- Merge from into to
4069: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4070: p_batch_party_id,
4071: 'HZ_CODE_ASSIGNMENTS',
4072: FROM_CA.code_assignment_id,
4073: l_to,
4074: 'Y',
4075: hz_utility_pub.created_by,