APPS.BEN_CWB_PERSON_INFO_PKG dependencies on BEN_CWB_PERSON_INFO

Line 1: package body BEN_CWB_PERSON_INFO_PKG as

1: package body BEN_CWB_PERSON_INFO_PKG as
2: /* $Header: bencwbpi.pkb 120.25 2011/10/14 07:22:05 naramasa ship $ */
3: --
4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33):=' ben_cwb_person_info_pkg.'; --Global package name

4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_person_info_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_fte_factor VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
11: g_salary_survey_id number := null; --Change to right value when implementing.
12: --

Line 355: l_performance_rating_type ben_cwb_person_info.performance_rating_type%type;

351: ,p_effective_date in date
352: ,p_called_from_benmngle in boolean default false)
353: is
354:
355: l_performance_rating_type ben_cwb_person_info.performance_rating_type%type;
356:
357: --vkodedal cursor to fetch survey_id from eit setup.
358: cursor c_survey_id(l_group_pl_id in number) is
359: select PLI_INFORMATION2 from ben_pl_extra_info

Line 748: from ben_cwb_person_info cpi

744: and paf_prev.pay_basis_id = ppb_prev.pay_basis_id (+);
745: --
746: cursor c_person_info is
747: select cpi.effective_date
748: from ben_cwb_person_info cpi
749: where cpi.group_per_in_ler_id = p_group_per_in_ler_id;
750:
751: --Bug fix 9760967
752: cursor csr_grp_plan_extra_info(p_group_pl_id number, p_lf_evt_ocrd_dt date)

Line 858: -- Open the cursor and update the details in ben_cwb_person_info

854: if g_debug then
855: hr_utility.set_location('show_appraisals_n_days:'|| l_appraisal_n_days, 15);
856: end if;
857:
858: -- Open the cursor and update the details in ben_cwb_person_info
859: -- It always should return only one row, but using the for to avoid
860: -- the declaration of too many local variables.
861:
862: for perinfo_rec in csr_person_info(

Line 914: update ben_cwb_person_info

910: l_annual_grd_mid_point := perinfo_rec.grd_mid_point * perinfo_rec.grade_annualization_factor;
911: l_annual_grd_max_val := perinfo_rec.grd_max_val * perinfo_rec.grade_annualization_factor;
912: --
913: if l_cpi_effective_date is not null then
914: update ben_cwb_person_info
915: set person_id = perinfo_rec.person_id
916: ,supervisor_id = perinfo_rec.supervisor_id
917: ,assignment_id = perinfo_rec.assignment_id
918: ,effective_date = perinfo_rec.effective_date

Line 1110: insert into ben_cwb_person_info

1106: --
1107: else
1108: -- The record does not exist. So insert the new record
1109: --
1110: insert into ben_cwb_person_info
1111: (group_per_in_ler_id
1112: ,person_id
1113: ,supervisor_id
1114: ,assignment_id

Line 1497: insert into ben_cwb_person_info

1493: hr_utility.set_location(l_proc, 50);
1494: end if;
1495: --
1496: if l_assignment_id is not null then
1497: insert into ben_cwb_person_info
1498: (group_per_in_ler_id
1499: ,person_id
1500: ,assignment_id
1501: ,effective_date

Line 1949: end BEN_CWB_PERSON_INFO_PKG;

1945: ,p_effective_date);
1946: --
1947: END;
1948: --
1949: end BEN_CWB_PERSON_INFO_PKG;
1950: --