APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PL_F

Line 19: (pl_id ben_pl_f.pl_id%type,

15: non_automatics_flag boolean,
16: max_enrt_esd date);
17: --
18: type g_pl_rec is record
19: (pl_id ben_pl_f.pl_id%type,
20: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
21: multi_row_edit_done boolean,
22: max_enrt_esd date);
23: --

Line 6354: (pl_id ben_pl_f.pl_id%type,

6350: non_automatics_flag boolean,
6351: max_enrt_esd date);
6352: --
6353: type pl_rec is record
6354: (pl_id ben_pl_f.pl_id%type,
6355: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
6356: multi_row_edit_done boolean,
6357: max_enrt_esd date);
6358: --

Line 9502: ben_pl_f pln

9498: --
9499: cursor c_flx_pen(c_person_id number,c_per_in_ler_id number,c_effective_date date ) is
9500: select pen.prtt_enrt_rslt_id,pen.pgm_id,pen.pl_id
9501: from ben_prtt_enrt_rslt_f pen,
9502: ben_pl_f pln
9503: where pen.person_id = c_person_id
9504: and pen.per_in_ler_id = c_per_in_ler_id
9505: and pen.pl_id = pln.pl_id
9506: and pln.invk_flx_cr_pl_flag = 'Y'

Line 9961: ben_pl_f

9957: l_def_plus_reinsate_flag varchar2(1) default 'N';
9958:
9959: cursor c_pl_typ_id(c_pl_id number) is
9960: select pl_typ_id from
9961: ben_pl_f
9962: where pl_id = c_pl_id
9963: and p_effective_date between effective_start_date
9964: and effective_end_date ;
9965:

Line 11670: (pl_id ben_pl_f.pl_id%type,

11666: non_automatics_flag boolean,
11667: max_enrt_esd date);
11668: --
11669: type pl_rec is record
11670: (pl_id ben_pl_f.pl_id%type,
11671: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
11672: multi_row_edit_done boolean,
11673: max_enrt_esd date);
11674: --