APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_DEPENDENT_DEMAND

Line 975: FROM MSC_INT_ASCP_DEPENDENT_DEMAND

971: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --USING_ASSEMBLY_DEMAND_DATE
972: ItemID, --USING_ASSEMBLY_ITEM_ID
973: 1, --DEMAND_TYPE
974: SYSDATE, '-1', SYSDATE, '-1'
975: FROM MSC_INT_ASCP_DEPENDENT_DEMAND
976: WHERE PLAN_ID=PlanIdVar;
977: EXCEPTION WHEN others THEN
978: g_ErrorCode := 'ERROR_UPDATE_DEMAND_FROM_ASCP_DEPENDENT_DEMAND_001002';
979: raise;