DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_FORM_QUERY

Line 87: FROM Msc_FORM_QUERY

83: NUMBER8,
84: NUMBER9,
85: LAST_UPDATED_BY,
86: NUMBER10, CHAR1
87: FROM Msc_FORM_QUERY
88: WHERE query_id = g_query_id
89: ORDER BY number2, number3, number4, number5, date1,
90: number6, number7,number1;
91:

Line 160: msc_form_query mfq

156:
157: CURSOR date_range IS
158: SELECT distinct mra.shift_date
159: FROM msc_net_resource_avail mra,
160: msc_form_query mfq
161: WHERE mra.plan_id = g_plan_id
162: and mra.organization_id = g_org_id
163: and mra.sr_instance_id = g_instance_id
164: and mra.department_id = g_department_id