APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_ENRT_BNFT

Line 1417: ,ben_enrt_bnft enb

1413: Select ecr.enrt_rt_id
1414: ,nvl(ecr.val,ecr.dflt_val) default_val
1415: ,ecr.ANN_DFLT_VAL
1416: From ben_enrt_rt ecr
1417: ,ben_enrt_bnft enb
1418: Where enb.enrt_bnft_id = ecr.enrt_bnft_id
1419: and ecr.business_group_id = p_business_group_id
1420: and enb.business_group_id = p_business_group_id
1421: and enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id

Line 1428: From ben_enrt_bnft

1424: ;
1425: --
1426: Cursor c_bnft (l_elig_per_elctbl_chc_id number) is
1427: Select enrt_bnft_id, val, dflt_val, entr_val_at_enrt_flag,cvg_mlt_cd
1428: From ben_enrt_bnft
1429: Where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
1430: and dflt_flag = 'Y'
1431: ;
1432: Type enrt_id_table is table of c_rt%rowtype index by binary_integer;

Line 1443: l_bnft_amt ben_enrt_bnft.val%type;

1439: l_validate boolean;
1440: l_actn varchar2(80);
1441: l_rt enrt_id_table;
1442: l_tot_rt number(5) := 0;
1443: l_bnft_amt ben_enrt_bnft.val%type;
1444: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1445: l_entr_flag varchar2(1);
1446: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1447: l_suspend_flag varchar2(30);

Line 1444: l_dflt_bnft_amt ben_enrt_bnft.val%type;

1440: l_actn varchar2(80);
1441: l_rt enrt_id_table;
1442: l_tot_rt number(5) := 0;
1443: l_bnft_amt ben_enrt_bnft.val%type;
1444: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1445: l_entr_flag varchar2(1);
1446: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1447: l_suspend_flag varchar2(30);
1448: l_prtt_enrt_interim_id number(15);

Line 1446: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;

1442: l_tot_rt number(5) := 0;
1443: l_bnft_amt ben_enrt_bnft.val%type;
1444: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1445: l_entr_flag varchar2(1);
1446: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1447: l_suspend_flag varchar2(30);
1448: l_prtt_enrt_interim_id number(15);
1449: l_datetrack_mode varchar2(30);
1450: l_effective_start_date date;

Line 1914: l_bnft_amt ben_enrt_bnft.val%type;

1910: l_proc Varchar2(80) := g_package || '.process_default enrollment';
1911: l_output_string Varchar2(80);
1912: l_validate boolean;
1913: l_actn varchar2(80);
1914: l_bnft_amt ben_enrt_bnft.val%type;
1915: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1916: l_datetrack_mode varchar2(30);
1917: l_pel_cnt binary_integer := 0;
1918: l_susp_flag boolean;

Line 1915: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;

1911: l_output_string Varchar2(80);
1912: l_validate boolean;
1913: l_actn varchar2(80);
1914: l_bnft_amt ben_enrt_bnft.val%type;
1915: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1916: l_datetrack_mode varchar2(30);
1917: l_pel_cnt binary_integer := 0;
1918: l_susp_flag boolean;
1919: l_output varchar2(2000);