APPS.BEN_CWB_DYN_CALC_PKG dependencies on BEN_CWB_PERSON_INFO_PKG

Line 359: l_min_val := ben_cwb_person_info_pkg.

355: function get_new_grd_min_val return number is
356: l_min_val number;
357: begin
358: if g_allocation_row.new_grd_min_val is null then
359: l_min_val := ben_cwb_person_info_pkg.
360: get_grd_min_val(g_allocation_row.new_grade_id,
361: g_allocation_row.pay_rate_id,
362: g_allocation_row.effective_date);
363: if l_min_val is null then

Line 376: l_max_val := ben_cwb_person_info_pkg.

372: function get_new_grd_max_val return number is
373: l_max_val number;
374: begin
375: if g_allocation_row.new_grd_max_val is null then
376: l_max_val := ben_cwb_person_info_pkg.
377: get_grd_max_val(g_allocation_row.new_grade_id,
378: g_allocation_row.pay_rate_id,
379: g_allocation_row.effective_date);
380: if l_max_val is null then

Line 393: l_mid_point := ben_cwb_person_info_pkg.

389: function get_new_grd_mid_point return number is
390: l_mid_point number;
391: begin
392: if g_allocation_row.new_grd_mid_point is null then
393: l_mid_point := ben_cwb_person_info_pkg.
394: get_grd_mid_point(g_allocation_row.new_grade_id,
395: g_allocation_row.pay_rate_id,
396: g_allocation_row.effective_date);
397: if l_mid_point is null then

Line 453: l_comparatio := ben_cwb_person_info_pkg.

449: l_comparatio number;
450: begin
451: if g_allocation_row.new_grd_comparatio is null then
452: if g_allocation_row.new_grade_id is not null then
453: l_comparatio := ben_cwb_person_info_pkg.
454: get_grd_comparatio(nvl(get_new_salary,
455: g_allocation_row.base_salary),
456: get_new_grd_mid_point);
457: else

Line 458: l_comparatio := ben_cwb_person_info_pkg.

454: get_grd_comparatio(nvl(get_new_salary,
455: g_allocation_row.base_salary),
456: get_new_grd_mid_point);
457: else
458: l_comparatio := ben_cwb_person_info_pkg.
459: get_grd_comparatio(get_new_salary,
460: g_allocation_row.grd_mid_point);
461: end if;
462: if l_comparatio is null then

Line 476: l_quartile := ben_cwb_person_info_pkg.

472: l_quartile varchar2(30);
473: begin
474: if g_allocation_row.new_grd_quartile is null then
475: if g_allocation_row.new_grade_id is not null then
476: l_quartile := ben_cwb_person_info_pkg.
477: get_grd_quartile(nvl(get_new_salary,
478: g_allocation_row.base_salary),
479: get_new_grd_min_val,
480: get_new_grd_max_val,

Line 483: l_quartile := ben_cwb_person_info_pkg.

479: get_new_grd_min_val,
480: get_new_grd_max_val,
481: get_new_grd_mid_point);
482: else
483: l_quartile := ben_cwb_person_info_pkg.
484: get_grd_quartile(get_new_salary,
485: g_allocation_row.grd_min_val,
486: g_allocation_row.grd_max_val,
487: g_allocation_row.grd_mid_point);