APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ENRT_BNFT

Line 2729: from ben_enrt_bnft

2725: from ben_elig_per_elctbl_chc
2726: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2727: or enrt_bnft_id in
2728: (select enrt_bnft_id
2729: from ben_enrt_bnft
2730: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);*/
2731:
2732: select ecc.elctbl_chc_ctfn_id,
2733: ecc.object_version_number

Line 2745: from ben_enrt_bnft

2741: ecc.object_version_number
2742: from ben_elctbl_chc_ctfn ecc
2743: where enrt_bnft_id in
2744: (select enrt_bnft_id
2745: from ben_enrt_bnft
2746: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2747:
2748:
2749: cursor c_rate is

Line 2759: from ben_enrt_bnft

2755: from ben_elig_per_elctbl_chc
2756: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2757: or enrt_bnft_id in
2758: (select enrt_bnft_id
2759: from ben_enrt_bnft
2760: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2761: */
2762:
2763: select ecr.enrt_rt_id,

Line 2776: from ben_enrt_bnft

2772: ecr.object_version_number
2773: from ben_enrt_rt ecr
2774: where enrt_bnft_id in
2775: (select enrt_bnft_id
2776: from ben_enrt_bnft
2777: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2778:
2779:
2780: cursor c_bnft is

Line 2783: from ben_enrt_bnft enb

2779:
2780: cursor c_bnft is
2781: select enb.enrt_bnft_id,
2782: enb.object_version_number
2783: from ben_enrt_bnft enb
2784: where elig_per_elctbl_chc_id in
2785: (select elig_per_elctbl_chc_id
2786: from ben_elig_per_elctbl_chc
2787: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);

Line 2855: ben_enrt_bnft_api.delete_enrt_bnft

2851: end loop;
2852:
2853: -- Choice Benefits:
2854: for l_bnft in c_bnft loop
2855: ben_enrt_bnft_api.delete_enrt_bnft
2856: (p_validate => false,
2857: p_enrt_bnft_id => l_bnft.enrt_bnft_id,
2858: p_object_version_number => l_bnft.object_version_number,
2859: p_effective_date => p_effective_date);