DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_FORM_QUERY

Line 75: FROM Msc_FORM_QUERY

71: NUMBER7,
72: NUMBER8,
73: NUMBER9,
74: LAST_UPDATED_BY
75: FROM Msc_FORM_QUERY
76: WHERE query_id = g_query_id
77: ORDER BY number2, number3, number4, number5, date1,
78: number6, number7,number1;
79:

Line 113: msc_form_query mfq

109:
110: CURSOR date_range IS
111: SELECT distinct mra.shift_date
112: FROM msc_net_resource_avail mra,
113: msc_form_query mfq
114: WHERE mra.plan_id = g_plan_id
115: and mra.organization_id = g_org_id
116: and mra.sr_instance_id = g_instance_id
117: and mra.department_id = g_department_id