DBA Data[Home] [Help]

APPS.BEN_CWB_APPROVALS dependencies on BEN_CWB_PERSON_TASKS

Line 64: from ben_cwb_person_tasks

60: cursor getTaskObjVerNum(c_group_per_in_ler_id in number,c_task_id in number) is
61: select
62: object_version_number ovn,
63: status_cd status
64: from ben_cwb_person_tasks
65: where group_per_in_ler_id = c_group_per_in_ler_id
66: and task_id = c_task_id
67: and group_pl_id=p_group_pl_id;
68:

Line 73: ben_cwb_person_tasks tsk

69: cursor getApprTaskId(c_group_per_in_ler_id in number) is
70: SELECT cwb_wksht_grp_id
71: from
72: ben_cwb_wksht_grp grp,
73: ben_cwb_person_tasks tsk
74: where grp.wksht_grp_cd = 'APPR'
75: and tsk.group_per_in_ler_id= c_group_per_in_ler_id
76: and tsk.task_id= grp.cwb_wksht_grp_id;
77:

Line 152: BEN_CWB_PERSON_TASKS_API.update_person_task

148:
149: --hr_utility.set_location('l_task_id '||l_task_id ,60);
150: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
151:
152: BEN_CWB_PERSON_TASKS_API.update_person_task
153: (
154: p_validate => false
155: ,p_group_per_in_ler_id => l_group_per_in_ler_id
156: ,p_group_pl_id => l_group_pl_id