APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_DEPENDENT_DEMAND

Line 1083: FROM MSC_INT_ASCP_DEPENDENT_DEMAND

1079: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --USING_ASSEMBLY_DEMAND_DATE
1080: ItemID, --USING_ASSEMBLY_ITEM_ID
1081: 1, --DEMAND_TYPE
1082: SYSDATE, '-1', SYSDATE, '-1'
1083: FROM MSC_INT_ASCP_DEPENDENT_DEMAND
1084: WHERE PLAN_ID=PlanIdVar;
1085: EXCEPTION WHEN others THEN
1086: g_ErrorCode := 'ERROR_UPDATE_DEMAND_FROM_ASCP_DEPENDENT_DEMAND_001002' || ' : ' || SQLERRM;
1087: raise;