APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ACTY_BASE_RT_F

Line 3015: hr_utility.set_location(' BEN_ACTY_BASE_RT_F CREATE_ACTY_BASE_RATE ',20);

3011: p_effective_date => p_effective_date);
3012: */
3013: begin
3014: if l_abr_id is null and (l_pl_id is not null or l_opt_id is not null) and r_abr.information266 is not null then
3015: hr_utility.set_location(' BEN_ACTY_BASE_RT_F CREATE_ACTY_BASE_RATE ',20);
3016: BEN_ACTY_BASE_RATE_API.CREATE_ACTY_BASE_RATE(
3017: P_EFFECTIVE_DATE => l_effective_date
3018: ,P_BUSINESS_GROUP_ID => p_business_group_id
3019: ,P_ABV_MX_ELCN_VAL_ALWD_FLAG => nvl(r_ABR.INFORMATION27,'N')

Line 3474: from ben_acty_base_rt_f

3470: hr_utility.set_location('1st crr for abr',222);
3471: begin
3472: select null
3473: into dummy
3474: from ben_acty_base_rt_f
3475: where acty_base_rt_id = l_abr_id
3476: and USES_VARBL_RT_FLAG = 'Y'
3477: and l_effective_date between effective_start_date
3478: and effective_end_date;

Line 3483: update ben_acty_base_rt_f

3479: exception
3480: when no_data_found then
3481: hr_utility.set_location('abr has vrbl flag No',222);
3482: begin
3483: update ben_acty_base_rt_f
3484: set USES_VARBL_RT_FLAG = 'Y'
3485: where acty_base_rt_id = l_abr_id;
3486: hr_utility.set_location('updated to Yes',223);
3487: exception