APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_TASKS

Line 269: From ben_cwb_person_tasks

265: Cursor csr_person_tasks_info(l_group_pl_id In Number, l_lf_evt_ocrd_dt Date)
266: IS
267: Select STATUS_CD
268: ,OBJECT_VERSION_NUMBER
269: From ben_cwb_person_tasks
270: Where GROUP_PER_IN_LER_ID = P_SEC_MGR_LER_ID
271: And TASK_ID = P_TASK_ID
272: And GROUP_PL_ID = l_group_pl_id
273: And LF_EVT_OCRD_DT = l_lf_evt_ocrd_dt ;

Line 278: l_status_cd ben_cwb_person_tasks.STATUS_CD%Type;

274:
275: l_proc varchar2(72) := g_package||'REFRESH_PERSON_TASKS';
276: l_rate_id Number;
277: l_group_pl_id Number;
278: l_status_cd ben_cwb_person_tasks.STATUS_CD%Type;
279: l_ovn Number;
280: l_lf_evt_ocrd_dt Date;
281: BEGIN
282:

Line 315: BEN_CWB_PERSON_TASKS_API.update_person_task

311: hr_utility.set_location('l_status_cd :'||l_status_cd,70);
312: hr_utility.set_location('l_ovn :'||l_ovn,80);
313:
314: If l_status_cd = 'NS' then
315: BEN_CWB_PERSON_TASKS_API.update_person_task
316: ( p_group_per_in_ler_id => P_SEC_MGR_LER_ID
317: ,p_task_id => P_TASK_ID
318: ,p_group_pl_id => l_group_pl_id
319: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 451: ben_cwb_person_tasks bcpt,

447: ) accesscd
448: from ben_cwb_person_info bcpi,
449: ben_cwb_person_groups bcpg,
450: ben_cwb_pl_dsgn bcpd,
451: ben_cwb_person_tasks bcpt,
452: ben_cwb_wksht_grp bcwg
453: WHERE bcpi.group_per_in_ler_id = P_MGR_PER_IN_LER_ID
454: AND bcpg.group_per_in_ler_id = bcpi.group_per_in_ler_id
455: AND bcpg.group_pl_id = bcpi.group_pl_id