DBA Data[Home] [Help]

APPS.MSC_RESOURCE_PKG dependencies on MSC_RESOURCE_REQUIREMENTS

Line 111: from msc_resource_requirements mrr,

107: fnd_global.user_id, sysdate,
108: sysdate, fnd_global.user_id, fnd_global.login_id,
109: fnd_global.conc_program_id, fnd_global.conc_login_id,
110: fnd_global.prog_appl_id, fnd_global.conc_request_id
111: from msc_resource_requirements mrr,
112: msc_department_resources mdr
113: where mrr.plan_id = p_plan_id
114: and mdr.plan_id = mrr.plan_id
115: and mdr.sr_instance_id = mrr.sr_instance_id

Line 236: msc_resource_requirements mrr,

232: sysdate, fnd_global.user_id, fnd_global.login_id,
233: fnd_global.conc_program_id, fnd_global.conc_login_id,
234: fnd_global.prog_appl_id, fnd_global.conc_request_id
235: from
236: msc_resource_requirements mrr,
237: msc_supplies ms,
238: msc_department_resources mdr
239: where mrr.plan_id = p_plan_id
240: and nvl(mrr.parent_id, l_constrained_plan) = 2