DBA Data[Home] [Help]

APPS.FLM_EKB_LEAD_TIME dependencies on FLM_EKB_RUN_DETAILS

Line 119: from flm_ekb_run_details

115: Begin
116:
117: select count(*)
118: into l_row_count
119: from flm_ekb_run_details
120: where organization_id = p_organization_id;
121:
122: if l_row_count = 0 then
123:

Line 144: from flm_ekb_run_details

140: Begin
141:
142: select lead_time_run_date
143: into l_last_run_date
144: from flm_ekb_run_details
145: where organization_id = p_organization_id;
146: Exception
147: When no_data_found then
148: null;

Line 227: Update flm_ekb_run_details

223:
224: End loop;
225:
226: if l_update_last_run = 'Y' then
227: Update flm_ekb_run_details
228: set lead_time_run_date = sysdate,
229: Last_lead_time_request_id = g_request_id,
230: last_updated_by = G_LOGIN_ID,
231: last_update_date = sysdate,