APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ACTY_BASE_RT_F

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

3012: p_effective_date => p_effective_date);
3013: */
3014: begin
3015: 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
3016: hr_utility.set_location(' BEN_ACTY_BASE_RT_F CREATE_ACTY_BASE_RATE ',20);
3017: BEN_ACTY_BASE_RATE_API.CREATE_ACTY_BASE_RATE(
3018: P_EFFECTIVE_DATE => l_effective_date
3019: ,P_BUSINESS_GROUP_ID => p_business_group_id
3020: ,P_ABV_MX_ELCN_VAL_ALWD_FLAG => nvl(r_ABR.INFORMATION27,'N')

Line 3475: from ben_acty_base_rt_f

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

Line 3484: update ben_acty_base_rt_f

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