APPS.HZ_PARTY_MERGE dependencies on HZ_CODE_ASSIGNMENTS

Line 4435: -- Handle DNB data in HZ_CODE_ASSIGNMENTS

4431: END;
4432: END LOOP;
4433:
4434: -- *******************************************
4435: -- Handle DNB data in HZ_CODE_ASSIGNMENTS
4436: FOR FROM_CA IN (
4437: SELECT code_assignment_id, class_category, class_code
4438: FROM HZ_CODE_ASSIGNMENTS
4439: WHERE owner_table_name = 'HZ_PARTIES'

Line 4438: FROM HZ_CODE_ASSIGNMENTS

4434: -- *******************************************
4435: -- Handle DNB data in HZ_CODE_ASSIGNMENTS
4436: FOR FROM_CA IN (
4437: SELECT code_assignment_id, class_category, class_code
4438: FROM HZ_CODE_ASSIGNMENTS
4439: WHERE owner_table_name = 'HZ_PARTIES'
4440: AND content_source_type = 'DNB'
4441: AND nvl(status, 'A') = 'A'
4442: AND owner_table_id = p_from_id) LOOP

Line 4446: FROM HZ_CODE_ASSIGNMENTS

4442: AND owner_table_id = p_from_id) LOOP
4443:
4444: BEGIN
4445: SELECT code_assignment_id INTO l_to
4446: FROM HZ_CODE_ASSIGNMENTS
4447: WHERE owner_table_name = 'HZ_PARTIES'
4448: AND content_source_type = 'DNB'
4449: AND nvl(status, 'A') = 'A'
4450: AND owner_table_id = x_to_id

Line 4460: 'HZ_CODE_ASSIGNMENTS',

4456: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4457: -- Merge to into from
4458: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4459: p_batch_party_id,
4460: 'HZ_CODE_ASSIGNMENTS',
4461: FROM_CA.code_assignment_id,
4462: l_to,
4463: 'Y',
4464: hz_utility_pub.created_by,

Line 4473: 'HZ_CODE_ASSIGNMENTS',

4469: ELSE -- To Newer
4470: -- Merge from into to
4471: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4472: p_batch_party_id,
4473: 'HZ_CODE_ASSIGNMENTS',
4474: FROM_CA.code_assignment_id,
4475: l_to,
4476: 'Y',
4477: hz_utility_pub.created_by,