DBA Data[Home] [Help]

APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ST_WO_MILESTONES

Line 1375: FROM MSC_ST_WO_MILESTONES mswm

1371: mswm.ORGANIZATION_ID,
1372: mswm.EARLIEST_START_DATE,
1373: mswm.TARGET_COMPLETION_DATE,
1374: mswm.SR_INSTANCE_ID
1375: FROM MSC_ST_WO_MILESTONES mswm
1376: WHERE mswm.deleted_flag = MSC_UTIL.SYS_NO
1377: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1378:
1379: CURSOR c_del IS

Line 1384: FROM MSC_ST_WO_MILESTONES mswm

1380: SELECT mswm.MILESTONE,
1381: mswm.VISIT_ID,
1382: mswm.ORGANIZATION_ID,
1383: mswm.SR_INSTANCE_ID
1384: FROM MSC_ST_WO_MILESTONES mswm
1385: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES
1386: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1387:
1388: BEGIN

Line 1442: ||' FROM MSC_ST_WO_MILESTONES mswm '

1438: ||':v_current_date, '
1439: ||':v_current_user, '
1440: ||':v_current_date, '
1441: ||':v_current_user '
1442: ||' FROM MSC_ST_WO_MILESTONES mswm '
1443: ||' WHERE mswm.deleted_flag = '||MSC_UTIL.SYS_NO
1444: ||' AND mswm.SR_INSTANCE_ID= '
1445: ||MSC_CL_COLLECTION.v_instance_id;
1446: