APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ENRT_RT

Line 4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type

4535: --
4536: TYPE cur_type IS REF CURSOR;
4537: --
4538: type g_efc_row is record
4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type
4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type

Line 4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type

4536: TYPE cur_type IS REF CURSOR;
4537: --
4538: type g_efc_row is record
4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type
4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type

Line 4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type

4537: --
4538: type g_efc_row is record
4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type
4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type

Line 4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type

4538: type g_efc_row is record
4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type
4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type

Line 4543: ,business_group_id ben_enrt_rt.business_group_id%type

4539: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type
4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type

Line 4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type

4540: ,elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type
4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type

Line 4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type

4541: ,enrt_bnft_id ben_enrt_rt.enrt_bnft_id%type
4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type

Line 4546: ,cmcd_val ben_enrt_rt.cmcd_val%type

4542: ,acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type
4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type

Line 4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type

4543: ,business_group_id ben_enrt_rt.business_group_id%type
4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type

Line 4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type

4544: ,cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%type
4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type

Line 4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type

4545: ,cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%type
4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type

Line 4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type

4546: ,cmcd_val ben_enrt_rt.cmcd_val%type
4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type

Line 4551: ,dflt_val ben_enrt_rt.dflt_val%type

4547: ,cmcd_dflt_val ben_enrt_rt.cmcd_dflt_val%type
4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type

Line 4552: ,ann_val ben_enrt_rt.ann_val%type

4548: ,ann_dflt_val ben_enrt_rt.ann_dflt_val%type
4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type

Line 4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type

4549: ,dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%type
4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type

Line 4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type

4550: ,dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%type
4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type

Line 4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type

4551: ,dflt_val ben_enrt_rt.dflt_val%type
4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type

Line 4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type

4552: ,ann_val ben_enrt_rt.ann_val%type
4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type

Line 4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type

4553: ,ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%type
4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type
4561: ,object_version_number ben_enrt_rt.object_version_number%type

Line 4558: ,val ben_enrt_rt.val%type

4554: ,ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%type
4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type
4561: ,object_version_number ben_enrt_rt.object_version_number%type
4562: );

Line 4559: ,last_update_date ben_enrt_rt.last_update_date%type

4555: ,mx_elcn_val ben_enrt_rt.mx_elcn_val%type
4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type
4561: ,object_version_number ben_enrt_rt.object_version_number%type
4562: );
4563: --

Line 4560: ,creation_date ben_enrt_rt.creation_date%type

4556: ,mn_elcn_val ben_enrt_rt.mn_elcn_val%type
4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type
4561: ,object_version_number ben_enrt_rt.object_version_number%type
4562: );
4563: --
4564: c_efc_rows cur_type;

Line 4561: ,object_version_number ben_enrt_rt.object_version_number%type

4557: ,incrmt_elcn_val ben_enrt_rt.incrmt_elcn_val%type
4558: ,val ben_enrt_rt.val%type
4559: ,last_update_date ben_enrt_rt.last_update_date%type
4560: ,creation_date ben_enrt_rt.creation_date%type
4561: ,object_version_number ben_enrt_rt.object_version_number%type
4562: );
4563: --
4564: c_efc_rows cur_type;
4565: --

Line 4805: from ben_enrt_rt_efc efc

4801: efc.MN_ELCN_VAL,
4802: efc.INCRMT_ELCN_VAL,
4803: efc.VAL,
4804: nvl(efc.pgm_uom,efc.nip_pl_uom) uom
4805: from ben_enrt_rt_efc efc
4806: where efc.efc_action_id = c_efc_action_id
4807: and efc.enrt_rt_id = c_ecr_id;
4808: --
4809: l_preconvdets c_preconvdets%rowtype;

Line 4845: l_from_str := ' FROM ben_enrt_rt ecr ';

4841: l_efc_batch := TRUE;
4842: --
4843: end if;
4844: --
4845: l_from_str := ' FROM ben_enrt_rt ecr ';
4846: --
4847: l_where_str := ' where (ecr.val is not null '
4848: ||' or ecr.ann_val is not null '
4849: ||' or ecr.dflt_val is not null '

Line 4867: l_from_str := l_from_str||', ben_enrt_rt_efc efc ';

4863: -- Build in batch specific restrictions
4864: --
4865: if l_efc_batch then
4866: --
4867: l_from_str := l_from_str||', ben_enrt_rt_efc efc ';
4868: l_where_str := l_where_str||' and efc.enrt_rt_id = ecr.enrt_rt_id '
4869: ||' and efc.efc_action_id = :action_id '
4870: ||' and ecr.enrt_rt_id > :pk1 '
4871: ||' and mod(ecr.enrt_rt_id, :total_workers) = :worker_id ';

Line 5626: update ben_enrt_rt ecr

5622: and (l_faterr_code is null
5623: or nvl(l_faterr_type,'ZZZZ') = 'CONVEXCLUSION')
5624: then
5625: --
5626: update ben_enrt_rt ecr
5627: set ecr.val = l_val,
5628: ecr.ann_val = l_ann_val,
5629: ecr.dflt_val = l_dflt_val,
5630: ecr.ann_dflt_val = l_ann_dflt_val,

Line 5779: (p_table_name => 'ben_enrt_rt'

5775: --
5776: -- Check that all rows have been converted or excluded
5777: --
5778: ben_efc_functions.conv_check
5779: (p_table_name => 'ben_enrt_rt'
5780: ,p_efctable_name => 'ben_enrt_rt_efc'
5781: ,p_tabwhere_clause => ' (cmcd_mn_elcn_val is not null '
5782: ||' or cmcd_mn_elcn_val is not null '
5783: ||' or cmcd_mx_elcn_val is not null '

Line 5780: ,p_efctable_name => 'ben_enrt_rt_efc'

5776: -- Check that all rows have been converted or excluded
5777: --
5778: ben_efc_functions.conv_check
5779: (p_table_name => 'ben_enrt_rt'
5780: ,p_efctable_name => 'ben_enrt_rt_efc'
5781: ,p_tabwhere_clause => ' (cmcd_mn_elcn_val is not null '
5782: ||' or cmcd_mn_elcn_val is not null '
5783: ||' or cmcd_mx_elcn_val is not null '
5784: ||' or cmcd_val is not null '