APPS.FLM_EKB_ACTUAL_DEMAND dependencies on FLM_EKB_RUN_DETAILS

Line 124: from flm_ekb_run_details

120: Begin
121:
122: select Actual_demand_run_date
123: into l_last_run_date
124: from flm_ekb_run_details
125: where organization_id = p_organization_id;
126: Exception
127: When no_data_found then
128: l_last_run_date := sysdate - 366;

Line 196: from flm_ekb_run_details

192: End loop;
193:
194: select count(*)
195: into l_row_count
196: from flm_ekb_run_details
197: where organization_id = p_organization_id;
198:
199: if l_row_count = 0 then
200: insert into flm_ekb_run_details(

Line 200: insert into flm_ekb_run_details(

196: from flm_ekb_run_details
197: where organization_id = p_organization_id;
198:
199: if l_row_count = 0 then
200: insert into flm_ekb_run_details(
201: Organization_id,
202: Actual_demand_run_date,
203: Last_demand_request_id,
204: Lead_time_run_date,

Line 234: Update flm_ekb_run_details

230: );
231:
232: else
233:
234: Update flm_ekb_run_details
235: set Actual_demand_run_date = sysdate,
236: Last_demand_request_id = G_REQUEST_ID,
237: last_updated_by = G_USER_ID,
238: last_update_date = sysdate,