APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_ORIG_SYSTEMS_B

Line 785: -- SSM SST Integration and Extension: data source will be a foreign key in hz_orig_systems_b

781: -- p_data_source_tab can not be empty.
782: -- Every data source must be a valid lookup code under
783: -- CONTENT_SOURCE_TYPE excluding SST.
784:
785: -- SSM SST Integration and Extension: data source will be a foreign key in hz_orig_systems_b
786: -- and will not be a lookup of type CONTENT_SOURCE_TYPE.
787: IF p_data_source_tab.COUNT = 0 THEN
788: fnd_message.set_name('AR', 'HZ_API_NO_DATA_SOURCE');
789: fnd_msg_pub.add;

Line 810: FROM HZ_ORIG_SYSTEMS_B

806: */
807: DECLARE
808: CURSOR c_valid_data_source IS
809: SELECT '1'
810: FROM HZ_ORIG_SYSTEMS_B
811: WHERE orig_system = p_data_source_tab(i)
812: AND sst_flag = 'Y';
813: l_dummy VARCHAR2(1);
814: BEGIN