DBA Data[Home] [Help]

APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ST_WORK_BREAKDOWN_STRUCT

Line 615: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs

611: SELECT mswbs.PARAMETER_NAME,
612: mswbs.DISPLAY_NAME,
613: mswbs.ORGANIZATION_ID,
614: mswbs.SR_INSTANCE_ID
615: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
616: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_NO
617: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
618:
619: CURSOR c_del IS

Line 624: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs

620: SELECT mswbs.PARAMETER_NAME,
621: mswbs.DISPLAY_NAME,
622: mswbs.ORGANIZATION_ID,
623: mswbs.SR_INSTANCE_ID
624: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
625: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES
626: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
627:
628: BEGIN

Line 677: ||' FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs '

673: ||':v_current_date, '
674: ||':v_current_user, '
675: ||':v_current_date, '
676: ||':v_current_user '
677: ||' FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs '
678: ||'WHERE mswbs.deleted_flag ='|| MSC_UTIL.SYS_NO
679: ||' AND mswbs.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id;
680:
681: IF (MSC_CL_COLLECTION.v_is_complete_refresh or