APPS.FLM_EKB_HEALTH_STATUS dependencies on FLM_EKB_RUN_DETAILS

Line 230: from flm_ekb_run_details

226:
227:
228: select count(*)
229: into l_row_count
230: from flm_ekb_run_details
231: where organization_id = p_organization_id;
232:
233: if l_row_count = 0 then
234: insert into flm_ekb_run_details(

Line 234: insert into flm_ekb_run_details(

230: from flm_ekb_run_details
231: where organization_id = p_organization_id;
232:
233: if l_row_count = 0 then
234: insert into flm_ekb_run_details(
235: Organization_id,
236: Actual_demand_run_date,
237: Last_demand_request_id,
238: Lead_time_run_date,

Line 268: Update flm_ekb_run_details

264: );
265:
266: else
267:
268: Update flm_ekb_run_details
269: set Health_status_run_date = sysdate,
270: Last_Health_status_request_id = G_REQUEST_ID,
271: last_updated_by = G_USER_ID,
272: last_update_date = sysdate,