DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on EAM_FORECASTED_WORK_ORDERS

Line 354: from eam_forecasted_work_orders

350: */
351: procedure transfer_to_wdj(p_group_id number) is
352: cursor pms is
353: select distinct pm_schedule_id, activity_association_id
354: from eam_forecasted_work_orders
355: where group_id = p_group_id
356: and process_flag = 'Y';
357:
358: l_pm_id number;

Line 376: delete from eam_forecasted_work_orders

372: END LOOP;
373: close pms;
374:
375: -- delete the records that has been moved to the mass load interface table
376: delete from eam_forecasted_work_orders
377: where group_id = p_group_id
378: and process_flag = 'Y';
379: end transfer_to_wdj;
380:

Line 411: from eam_forecasted_work_orders

407: attribute12,
408: attribute13,
409: attribute14,
410: attribute15
411: from eam_forecasted_work_orders
412: where pm_schedule_id = p_pm_id
413: and group_id = p_group_id
414: and process_flag = 'Y';
415: