APPS.BEN_CTP_BUS dependencies on BEN_PL_TYP_F

Line 326: from ben_pl_typ_f

322: is
323: l_proc varchar2(72) := g_package||' chk_plan_typ_temporal ';
324: l_dummy char(1);
325: cursor c1 is select null
326: from ben_pl_typ_f
327: where pl_typ_id = p_pl_typ_id
328: and p_effective_date between effective_start_date
329: and effective_end_date
330: and business_group_id + 0 = p_business_group_id

Line 4154: -- Maximum Enrolled Allowed Override Number must be greater than BEN_PL_TYP_F

4150: -- |------< chk_mx_enrd_alwd_ovrid_num >------|
4151: -- ----------------------------------------------------------------------------
4152: --
4153: -- Description
4154: -- Maximum Enrolled Allowed Override Number must be greater than BEN_PL_TYP_F
4155: -- Maximum enrolled Allowed Number.
4156: --
4157: -- Pre Conditions
4158: -- None.

Line 4188: from ben_pl_typ_f pt

4184: l_api_updating boolean;
4185: l_value number;
4186: --
4187: cursor c1 is select mx_enrl_alwd_num
4188: from ben_pl_typ_f pt
4189: where pt.pl_typ_id = p_pl_typ_id
4190: and pt.business_group_id +0 = p_business_group_id
4191: and p_effective_date between pt.effective_start_date
4192: and pt.effective_end_date;

Line 4238: -- Minimum Enrolled Required Override Number must be greater than BEN_PL_TYP_F

4234: -- |------< chk_mn_enrd_rqd_ovrid_num >------|
4235: -- ----------------------------------------------------------------------------
4236: --
4237: -- Description
4238: -- Minimum Enrolled Required Override Number must be greater than BEN_PL_TYP_F
4239: -- Minimum enrolled Required Number.
4240: --
4241: -- Pre Conditions
4242: -- None.

Line 4272: from ben_pl_typ_f pt

4268: l_api_updating boolean;
4269: l_value number;
4270: --
4271: cursor c1 is select mn_enrl_rqd_num
4272: from ben_pl_typ_f pt
4273: where pt.pl_typ_id = p_pl_typ_id
4274: and pt.business_group_id +0 = p_business_group_id
4275: and p_effective_date between pt.effective_start_date
4276: and pt.effective_end_date;

Line 4805: (p_base_table_name => 'ben_pl_typ_f',

4801: Raise l_integrity_error;
4802: End If;
4803: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4804: NOT (dt_api.check_min_max_dates
4805: (p_base_table_name => 'ben_pl_typ_f',
4806: p_base_key_column => 'pl_typ_id',
4807: p_base_key_value => p_pl_typ_id,
4808: p_from_date => p_validation_start_date,
4809: p_to_date => p_validation_end_date))) Then

Line 4810: l_table_name := 'ben_pl_typ_f';

4806: p_base_key_column => 'pl_typ_id',
4807: p_base_key_value => p_pl_typ_id,
4808: p_from_date => p_validation_start_date,
4809: p_to_date => p_validation_end_date))) Then
4810: l_table_name := 'ben_pl_typ_f';
4811: Raise l_integrity_error;
4812: End If;
4813: --
4814: End If;