DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_VISITS

Line 4653: FROM MSC_ST_VISITS msv

4649: msv.VISIT_START_DATE,
4650: msv.VISIT_END_DATE,
4651: msv.ORGANIZATION_ID,
4652: msv.SR_INSTANCE_ID
4653: FROM MSC_ST_VISITS msv
4654: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO
4655: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4656:
4657: CURSOR c_del IS

Line 4662: FROM MSC_ST_VISITS msv

4658: SELECT
4659: msv.VISIT_ID,
4660: msv.ORGANIZATION_ID,
4661: msv.SR_INSTANCE_ID
4662: FROM MSC_ST_VISITS msv
4663: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES
4664: and msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4665:
4666: BEGIN