APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_EXPORT_BUCKETS

Line 881: FROM MSC_INT_ASCP_EXPORT_BUCKETS, MSC_PLANS

877: TO_DATE(BktStartDate,'YYYY-MM-DD'), TO_DATE(BktEndDate,'YYYY-MM-DD')-1/86400,
878: TO_NUMBER(DaysInBucket), TO_NUMBER(BucketType),
879: SYSDATE, '-1',
880: SYSDATE, '-1'
881: FROM MSC_INT_ASCP_EXPORT_BUCKETS, MSC_PLANS
882: WHERE PLANID=PlanIdVar AND
883: MSC_PLANS.PLAN_ID=PlanIdVar;
884: EXCEPTION WHEN others THEN
885: g_ErrorCode := 'ERROR_UPDATE_PLAN_BUCKETS_001001' || ' : ' || SQLERRM;