DBA Data[Home] [Help]

APPS.MSC_BUDGET_DETAILS dependencies on MSC_FORM_QUERY

Line 148: delete msc_form_query;

144: org_level number := 2;
145:
146: begin
147:
148: delete msc_form_query;
149:
150: open get_bucket_dates;
151: fetch get_bucket_dates into l_start_date , l_end_date, l_bucket_type;
152: close get_bucket_dates;

Line 236: insert into msc_form_query

232: fetch safety_stocks_c into l_target_ss, l_achieved_ss;
233: close safety_stocks_c;
234:
235:
236: insert into msc_form_query
237: (query_id,
238: number1, --item
239: number2, --budget value
240: number3, --inv value