APPS.HZ_MERGE_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5122:
5123: --6696774 Start
5124: l_par_exists VARCHAR2(1);
5125: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

Line 5213: FROM HZ_ORIG_SYSTEMS_B

5209:
5210: IF (l_from_request_id <> hz_utility_pub.request_id) THEN
5211:
5212: SELECT orig_system_type INTO from_cont_source_type --5404244
5213: FROM HZ_ORIG_SYSTEMS_B
5214: WHERE orig_system = from_cont_source;
5215: OPEN c_check_valid_merge(from_start_date, from_end_date, from_cont_source_type,from_cont_source);
5216: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id, l_to_rel_status;
5217: IF ((c_check_valid_merge%FOUND) AND

Line 5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5579:
5580: --6696774 start
5581: l_par_exists VARCHAR2(1);
5582: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

Line 5673: FROM HZ_ORIG_SYSTEMS_B

5669:
5670: IF (l_from_request_id <> hz_utility_pub.request_id) THEN
5671:
5672: SELECT orig_system_type INTO from_cont_source_type --5404244
5673: FROM HZ_ORIG_SYSTEMS_B
5674: WHERE orig_system = from_cont_source;
5675:
5676: OPEN c_check_valid_merge(from_start_date,from_end_date,from_cont_source_type,from_cont_source);
5677: