APPS.MSC_CL_PULL dependencies on MSC_CL_REFRESH_S

Line 4268: Select MSC_CL_REFRESH_S.NEXTVAL

4264: pTOTAL_TASK_NUMBER OUT NOCOPY NUMBER)
4265: IS
4266: BEGIN
4267:
4268: Select MSC_CL_REFRESH_S.NEXTVAL
4269: into pREFRESH_ID
4270: from dual;
4271:
4272: pTOTAL_TASK_NUMBER := TOTAL_TASK_NUMBER;

Line 4292: LRID= msc_cl_refresh_s.currval,

4288: UPDATE MSC_APPS_INSTANCES
4289: SET APPS_LRN= pLRN,
4290: LRTYPE= DECODE( pRTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4291: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4292: LRID= msc_cl_refresh_s.currval,
4293: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4294: LAST_UPDATE_DATE= SYSDATE,
4295: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4296: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,

Line 4308: LRID= msc_cl_refresh_s.currval,

4304: MSC_UTIL.G_INCREMENTAL, 'I',
4305: MSC_UTIL.G_PARTIAL, 'P',
4306: MSC_UTIL.G_CONT, 'T'),
4307: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, DECODE(pRTYPE,MSC_UTIL.G_INCREMENTAL,'I', 'C'), 'I'),
4308: LRID= msc_cl_refresh_s.currval,
4309: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4310: LAST_UPDATE_DATE= SYSDATE,
4311: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4312: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,