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 5956: (pgm_id ben_pgm_f.pgm_id%type,

5952: l_rt_table g_rt_table;
5953: l_count number;
5954: --
5955: type pgm_rec is record
5956: (pgm_id ben_pgm_f.pgm_id%type,
5957: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
5958: multi_row_edit_done boolean,
5959: non_automatics_flag boolean,
5960: max_enrt_esd date);

Line 8710: from ben_pgm_f pgm

8706: cursor c_flx_pgm(c_pgm_id number,c_effective_date date ) is
8707: select decode(pgm_typ_cd,'COBRAFLX','Y',
8708: 'FLEX','Y',
8709: 'FPC','Y','N') pgm_typ_cd
8710: from ben_pgm_f pgm
8711: where pgm.pgm_id = c_pgm_id
8712: and c_effective_date between pgm.effective_start_date
8713: and pgm.effective_end_date ;
8714: --

Line 10182: (pgm_id ben_pgm_f.pgm_id%type,

10178: l_rt_table g_rt_table;
10179: l_count number;
10180: --
10181: type pgm_rec is record
10182: (pgm_id ben_pgm_f.pgm_id%type,
10183: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
10184: multi_row_edit_done boolean,
10185: non_automatics_flag boolean,
10186: max_enrt_esd date);