APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_ENRT_RT

Line 1642: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)

1638: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1639: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1640: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1641: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1642: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1643: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)
1644: -- BEN_ELIG_CVRD_DPNT_F (PDP)
1645: -- BEN_ELIG_PER_F (PEP)
1646: -- BEN_ELIG_PER_OPT_F (EPO)

Line 3488: from ben_enrt_rt ecr

3484: -- Get the ecr info to store the link between ecr and prv rows.
3485: --
3486: cursor c_ecr(v_prtt_rt_val_id in number) is
3487: select ecr.*
3488: from ben_enrt_rt ecr
3489: where ecr.prtt_rt_val_id = v_prtt_rt_val_id
3490: and ecr.business_group_id = p_business_group_id;
3491: --
3492: l_ecr c_ecr%rowtype;

Line 5687: -- Pbodla : Now insert the link between ben_enrt_rt and

5683: l_ref_obj_pk_id,
5684: l_ref_obj_table_name;
5685: exit when c_ben_prtt_rt_val%notfound;
5686: --
5687: -- Pbodla : Now insert the link between ben_enrt_rt and
5688: -- ben_prtt_rt_val into bacup table lcr
5689: -- as this info is lost when the prv rows are set to BCKDT status.
5690: --tilak: in case the cursor fails the previous data carried forward
5691: -- to avoid this the data is initialised

Line 5775: (p_base_table_name => 'ben_enrt_rt',

5771: -- Get the object version number for the update
5772: --
5773: l_ecr.object_version_number :=
5774: dt_api.get_object_version_number
5775: (p_base_table_name => 'ben_enrt_rt',
5776: p_base_key_column => 'enrt_rt_id',
5777: p_base_key_value => l_ecr.enrt_rt_id)-1;
5778:
5779: --

Line 5780: open c_bkp_row('BEN_ENRT_RT',

5776: p_base_key_column => 'enrt_rt_id',
5777: p_base_key_value => l_ecr.enrt_rt_id)-1;
5778:
5779: --
5780: open c_bkp_row('BEN_ENRT_RT',
5781: p_per_in_ler_id,
5782: l_ecr.enrt_rt_id,
5783: l_ecr.object_version_number);
5784: fetch c_bkp_row into l_row_id;

Line 5799: 'BEN_ENRT_RT',

5795: per_in_ler_id,
5796: business_group_id,
5797: object_version_number)
5798: values (
5799: 'BEN_ENRT_RT',
5800: l_ecr.enrt_rt_id,
5801: l_ecr.prtt_rt_val_id,
5802: p_per_in_ler_id,
5803: l_ecr.business_group_id,