APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PGM_F

Line 12: (pgm_id ben_pgm_f.pgm_id%type,

8: g_sys_date date := trunc(sysdate);
9: g_bckt_csd_lf_evt_ocrd_dt date;
10: --
11: type g_pgm_rec is record
12: (pgm_id ben_pgm_f.pgm_id%type,
13: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
14: multi_row_edit_done boolean,
15: non_automatics_flag boolean,
16: max_enrt_esd date);

Line 6347: (pgm_id ben_pgm_f.pgm_id%type,

6343: l_rt_table g_rt_table;
6344: l_count number;
6345: --
6346: type pgm_rec is record
6347: (pgm_id ben_pgm_f.pgm_id%type,
6348: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
6349: multi_row_edit_done boolean,
6350: non_automatics_flag boolean,
6351: max_enrt_esd date);

Line 9516: from ben_pgm_f pgm

9512: cursor c_flx_pgm(c_pgm_id number,c_effective_date date ) is
9513: select decode(pgm_typ_cd,'COBRAFLX','Y',
9514: 'FLEX','Y',
9515: 'FPC','Y','N') pgm_typ_cd
9516: from ben_pgm_f pgm
9517: where pgm.pgm_id = c_pgm_id
9518: and c_effective_date between pgm.effective_start_date
9519: and pgm.effective_end_date ;
9520: --

Line 11663: (pgm_id ben_pgm_f.pgm_id%type,

11659: l_rt_table g_rt_table;
11660: l_count number;
11661: --
11662: type pgm_rec is record
11663: (pgm_id ben_pgm_f.pgm_id%type,
11664: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
11665: multi_row_edit_done boolean,
11666: non_automatics_flag boolean,
11667: max_enrt_esd date);