APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_ENRT_BNFT

Line 1471: ,ben_enrt_bnft enb

1467: Select ecr.enrt_rt_id
1468: ,nvl(ecr.val,ecr.dflt_val) default_val
1469: ,ecr.ANN_DFLT_VAL
1470: From ben_enrt_rt ecr
1471: ,ben_enrt_bnft enb
1472: Where enb.enrt_bnft_id = ecr.enrt_bnft_id
1473: and ecr.business_group_id = p_business_group_id
1474: and enb.business_group_id = p_business_group_id
1475: and enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id

Line 1482: From ben_enrt_bnft

1478: ;
1479: --
1480: Cursor c_bnft (l_elig_per_elctbl_chc_id number) is
1481: Select enrt_bnft_id, val, dflt_val, entr_val_at_enrt_flag,cvg_mlt_cd
1482: From ben_enrt_bnft
1483: Where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
1484: and dflt_flag = 'Y'
1485: ;
1486: Type enrt_id_table is table of c_rt%rowtype index by binary_integer;

Line 1529: l_bnft_amt ben_enrt_bnft.val%type;

1525: l_validate boolean;
1526: l_actn varchar2(80);
1527: l_rt enrt_id_table;
1528: l_tot_rt number(5) := 0;
1529: l_bnft_amt ben_enrt_bnft.val%type;
1530: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1531: l_entr_flag varchar2(1);
1532: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1533: l_suspend_flag varchar2(30);

Line 1530: l_dflt_bnft_amt ben_enrt_bnft.val%type;

1526: l_actn varchar2(80);
1527: l_rt enrt_id_table;
1528: l_tot_rt number(5) := 0;
1529: l_bnft_amt ben_enrt_bnft.val%type;
1530: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1531: l_entr_flag varchar2(1);
1532: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1533: l_suspend_flag varchar2(30);
1534: l_prtt_enrt_interim_id number(15);

Line 1532: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;

1528: l_tot_rt number(5) := 0;
1529: l_bnft_amt ben_enrt_bnft.val%type;
1530: l_dflt_bnft_amt ben_enrt_bnft.val%type;
1531: l_entr_flag varchar2(1);
1532: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
1533: l_suspend_flag varchar2(30);
1534: l_prtt_enrt_interim_id number(15);
1535: l_datetrack_mode varchar2(30);
1536: l_effective_start_date date;

Line 2063: l_bnft_amt ben_enrt_bnft.val%type;

2059: l_proc Varchar2(80) := g_package || '.process_default enrollment';
2060: l_output_string Varchar2(80);
2061: l_validate boolean;
2062: l_actn varchar2(80);
2063: l_bnft_amt ben_enrt_bnft.val%type;
2064: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
2065: l_datetrack_mode varchar2(30);
2066: l_pel_cnt binary_integer := 0;
2067: l_susp_flag boolean;

Line 2064: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;

2060: l_output_string Varchar2(80);
2061: l_validate boolean;
2062: l_actn varchar2(80);
2063: l_bnft_amt ben_enrt_bnft.val%type;
2064: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
2065: l_datetrack_mode varchar2(30);
2066: l_pel_cnt binary_integer := 0;
2067: l_susp_flag boolean;
2068: l_output varchar2(2000);