APPS.BEN_CPP_BUS dependencies on BEN_PGM_F

Line 2368: -- If Program Provides no Automatic Enrollment Flag (ben_pgm_f) = 'YES' then

2364: -- |------< chk_dflt_enrt_cd_dpndcy >------|
2365: -- ----------------------------------------------------------------------------
2366: --
2367: -- Description
2368: -- If Program Provides no Automatic Enrollment Flag (ben_pgm_f) = 'YES' then
2369: -- Enrollment Method Code cannot be 'Automatic'.
2370: --
2371: --
2372: -- Pre Conditions

Line 2406: from ben_pgm_f pgm

2402: l_api_updating boolean;
2403: l_value varchar2(30);
2404: --
2405: cursor c1 is select pgm_prvds_no_auto_enrt_flag
2406: from ben_pgm_f pgm
2407: where pgm.pgm_id = p_pgm_id
2408: and pgm.business_group_id +0 = p_business_group_id
2409: and p_effective_date between pgm.effective_start_date
2410: and pgm.effective_end_date;

Line 2456: -- If Program Provides no Default Enrollment Flag (ben_pgm_f) = 'YES' then

2452: -- |------< chk_dflt_dpndcy >------|
2453: -- ----------------------------------------------------------------------------
2454: --
2455: -- Description
2456: -- If Program Provides no Default Enrollment Flag (ben_pgm_f) = 'YES' then
2457: -- the following fields must be null: Default Flag, Default Enrollment
2458: -- Method Code, and Default Enrollment Determination Rule.
2459: --
2460: --

Line 2498: from ben_pgm_f pgm

2494: l_api_updating boolean;
2495: l_value varchar2(30);
2496: --
2497: cursor c1 is select pgm_prvds_no_dflt_enrt_flag
2498: from ben_pgm_f pgm
2499: where pgm.pgm_id = p_pgm_id
2500: and pgm.business_group_id +0 = p_business_group_id
2501: and p_effective_date between pgm.effective_start_date
2502: and pgm.effective_end_date;

Line 2823: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;

2819: --
2820: l_proc varchar2(72) := g_package || 'chk_invk_flx_crpl_per_pgm';
2821: l_count number;
2822: l_flag varchar2(30);
2823: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;
2824: --
2825: cursor pl_is_flex is select invk_flx_cr_pl_flag
2826: from ben_pl_f
2827: where pl_id = p_pl_id

Line 2833: from ben_pgm_f

2829: and effective_end_date
2830: and business_group_id = p_business_group_id;
2831: --
2832: cursor c_flex_pgm is select pgm_typ_cd
2833: from ben_pgm_f
2834: where pgm_id = p_pgm_id
2835: and p_effective_date between effective_start_date and effective_end_date
2836: and business_group_id = p_business_group_id;
2837: --

Line 4284: (p_base_table_name => 'ben_pgm_f',

4280: Raise l_integrity_error;
4281: End If;
4282: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4283: NOT (dt_api.check_min_max_dates
4284: (p_base_table_name => 'ben_pgm_f',
4285: p_base_key_column => 'pgm_id',
4286: p_base_key_value => p_pgm_id,
4287: p_from_date => p_validation_start_date,
4288: p_to_date => p_validation_end_date))) Then

Line 4289: l_table_name := 'ben_pgm_f';

4285: p_base_key_column => 'pgm_id',
4286: p_base_key_value => p_pgm_id,
4287: p_from_date => p_validation_start_date,
4288: p_to_date => p_validation_end_date))) Then
4289: l_table_name := 'ben_pgm_f';
4290: Raise l_integrity_error;
4291: End If;
4292: --
4293: End If;