DBA Data[Home] [Help]

APPS.PQP_GB_OSP_TEMPLATE dependencies on BEN_PL_F

Line 229: UPDATE ben_pl_f

225:
226: -- 1. making plans pending -- unusable untill it is resetup as a scheme
227:
228: -- call api here....making do with hard update to get over date track problems
229: UPDATE ben_pl_f
230: SET pl_stat_cd = 'P'
231: ,object_version_number = object_version_number + 1
232: WHERE pl_id = p_pl_id
233: AND p_effective_date BETWEEN effective_start_date

Line 291: UPDATE ben_pl_f

287: debug(l_proc_name,l_proc_step);
288: END IF;
289:
290: -- call api here....making do with hard update to get over date track problems
291: UPDATE ben_pl_f
292: SET pl_stat_cd = 'A'
293: ,object_version_number = object_version_number + 1
294: WHERE pl_id = p_pl_id
295: AND p_effective_date BETWEEN effective_start_date