DBA Data[Home] [Help]

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 5963: (pl_id ben_pl_f.pl_id%type,

5959: non_automatics_flag boolean,
5960: max_enrt_esd date);
5961: --
5962: type pl_rec is record
5963: (pl_id ben_pl_f.pl_id%type,
5964: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
5965: multi_row_edit_done boolean,
5966: max_enrt_esd date);
5967: --

Line 8696: ben_pl_f pln

8692: --
8693: cursor c_flx_pen(c_person_id number,c_per_in_ler_id number,c_effective_date date ) is
8694: select pen.prtt_enrt_rslt_id,pen.pgm_id,pen.pl_id
8695: from ben_prtt_enrt_rslt_f pen,
8696: ben_pl_f pln
8697: where pen.person_id = c_person_id
8698: and pen.per_in_ler_id = c_per_in_ler_id
8699: and pen.pl_id = pln.pl_id
8700: and pln.invk_flx_cr_pl_flag = 'Y'

Line 10189: (pl_id ben_pl_f.pl_id%type,

10185: non_automatics_flag boolean,
10186: max_enrt_esd date);
10187: --
10188: type pl_rec is record
10189: (pl_id ben_pl_f.pl_id%type,
10190: enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
10191: multi_row_edit_done boolean,
10192: max_enrt_esd date);
10193: --