DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PGM_F

Line 2348: from ben_pgm_f pgm,

2344: --
2345:
2346: cursor c_pgm_typ_cd(v_elig_per_elctbl_chc_id in number) is
2347: select pgm.pgm_typ_cd
2348: from ben_pgm_f pgm,
2349: ben_elig_per_elctbl_chc epe
2350: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
2351: and pgm.pgm_id = epe.pgm_id
2352: and p_effective_date between pgm.effective_start_date

Line 2369: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;

2365: --
2366: --ICM Changes
2367: l_batch_param_rec benutils.g_batch_param_rec;
2368: l_year varchar2(30);
2369: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;
2370: --
2371: l_benmngle_parm_rec benutils.g_batch_param_rec;
2372: l_env_rec ben_env_object.g_global_env_rec_type;
2373: --

Line 4733: from ben_pgm_f pgm

4729: l_get_epe_pl_yr get_epe_pl_yr%rowtype;
4730:
4731: cursor get_pgm_acty_ref_cd (p_pgm_id number) is
4732: select pgm.acty_ref_perd_cd
4733: from ben_pgm_f pgm
4734: where pgm.pgm_id = p_pgm_id
4735: and p_effective_date between
4736: pgm.effective_start_date and pgm.effective_end_date;
4737: