APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_PERSON_TASKS

Line 931: from ben_cwb_person_tasks t,

927: IS
928:
929: cursor c_cwb_person_task is
930: select t.task_id, t.object_version_number, t.status_cd, t.task_last_update_date, g.wksht_grp_cd
931: from ben_cwb_person_tasks t,
932: ben_cwb_wksht_grp g
933: where t.group_per_in_ler_id = p_per_in_ler_id
934: and CWB_WKSHT_GRP_ID = t.task_id;
935:

Line 940: BEN_CWB_PERSON_TASKS_API.update_person_task

936: BEGIN
937:
938: FOR l_task in c_cwb_person_task LOOP
939: IF(l_task.object_version_number IS NOT NULL AND l_task.task_id IS NOT NULL AND (nvl(l_task.status_cd,'XX') = 'CO' AND nvl(l_task.wksht_grp_cd,'XX') = 'RVW')) THEN
940: BEN_CWB_PERSON_TASKS_API.update_person_task
941: ( p_group_per_in_ler_id => p_per_in_ler_id
942: ,p_task_id => l_task.task_id
943: ,p_status_cd => 'IP'
944: ,p_task_last_update_date => nvl(p_effective_date,l_task.task_last_update_date) --additional fix for bug 12581404

Line 948: BEN_CWB_PERSON_TASKS_API.update_person_task

944: ,p_task_last_update_date => nvl(p_effective_date,l_task.task_last_update_date) --additional fix for bug 12581404
945: ,p_object_version_number => l_task.object_version_number
946: );
947: ELSIF(l_task.object_version_number IS NOT NULL AND l_task.task_id IS NOT NULL AND (nvl(l_task.status_cd,'XX') = 'CO' AND nvl(l_task.wksht_grp_cd,'RVW') <> 'RVW')) THEN
948: BEN_CWB_PERSON_TASKS_API.update_person_task
949: ( p_group_per_in_ler_id => p_per_in_ler_id
950: ,p_task_id => l_task.task_id
951: ,p_status_cd => 'IP'
952: ,p_object_version_number => l_task.object_version_number