eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PGM_F

Line 2223: from ben_pgm_f pgm,

2219: --
2220:
2221: cursor c_pgm_typ_cd(v_elig_per_elctbl_chc_id in number) is
2222: select pgm.pgm_typ_cd
2223: from ben_pgm_f pgm,
2224: ben_elig_per_elctbl_chc epe
2225: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
2226: and pgm.pgm_id = epe.pgm_id
2227: and p_effective_date between pgm.effective_start_date

Line 2244: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;

2240: --
2241: --ICM Changes
2242: l_batch_param_rec benutils.g_batch_param_rec;
2243: l_year varchar2(30);
2244: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;
2245: --
2246: l_benmngle_parm_rec benutils.g_batch_param_rec;
2247: l_env_rec ben_env_object.g_global_env_rec_type;
2248: --

Line 4413: from ben_pgm_f pgm

4409: l_get_epe_pl_yr get_epe_pl_yr%rowtype;
4410:
4411: cursor get_pgm_acty_ref_cd (p_pgm_id number) is
4412: select pgm.acty_ref_perd_cd
4413: from ben_pgm_f pgm
4414: where pgm.pgm_id = p_pgm_id
4415: and p_effective_date between
4416: pgm.effective_start_date and pgm.effective_end_date;
4417: