APPS.HZ_MERGE_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 5113: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

5109: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5110: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5111: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5112: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5113: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5114:
5115: --6696774 Start
5116: l_par_exists VARCHAR2(1);
5117: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

Line 5198: FROM HZ_ORIG_SYSTEMS_B

5194: fetch c_start_end_date into from_start_date,from_end_date,from_cont_source;
5195: close c_start_end_date;
5196:
5197: SELECT orig_system_type INTO from_cont_source_type --5404244
5198: FROM HZ_ORIG_SYSTEMS_B
5199: WHERE orig_system = from_cont_source;
5200: OPEN c_check_valid_merge(from_start_date, from_end_date, from_cont_source_type,from_cont_source);
5201: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id;
5202: IF c_check_valid_merge%FOUND AND

Line 5505: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

5501: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5502: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5503: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5504: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5505: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5506:
5507: --6696774 start
5508: l_par_exists VARCHAR2(1);
5509: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

Line 5593: FROM HZ_ORIG_SYSTEMS_B

5589: fetch c_start_end_date into from_start_date,from_end_date,from_cont_source;
5590: close c_start_end_date;
5591:
5592: SELECT orig_system_type INTO from_cont_source_type --5404244
5593: FROM HZ_ORIG_SYSTEMS_B
5594: WHERE orig_system = from_cont_source;
5595:
5596:
5597: OPEN c_check_valid_merge(from_start_date,from_end_date,from_cont_source_type,from_cont_source);