APPS.MSC_RESTORE_FIRM_PO dependencies on MSC_STORE_RESOURCE_REQS

Line 36: FROM MSC_STORE_RESOURCE_REQS

32: BEGIN
33: DELETE FROM MSC_RESOURCE_REQUIREMENTS
34: WHERE (PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID) IN
35: (SELECT PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID
36: FROM MSC_STORE_RESOURCE_REQS
37: WHERE plan_id = lv_plan_id)
38: AND plan_id = lv_plan_id;
39: LOG_MESSAGE('Deleted Resource Requirements : ' || SQL%ROWCOUNT);
40:

Line 228: FROM MSC_STORE_RESOURCE_REQS res

224: ,res.UNBUCKETED_START_DATE
225: ,res.UNBUCKETED_END_DATE
226: ,res.ACTUAL_START_DATE
227: ,res.TOTAL_RESOURCE_HOURS
228: FROM MSC_STORE_RESOURCE_REQS res
229: WHERE res.PLAN_ID = lv_plan_id;
230:
231: LOG_MESSAGE('Inserted Resource Requirements : ' || SQL%ROWCOUNT);
232: EXCEPTION