APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ENRT_BNFT

Line 2724: from ben_enrt_bnft

2720: from ben_elig_per_elctbl_chc
2721: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2722: or enrt_bnft_id in
2723: (select enrt_bnft_id
2724: from ben_enrt_bnft
2725: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);*/
2726:
2727: select ecc.elctbl_chc_ctfn_id,
2728: ecc.object_version_number

Line 2740: from ben_enrt_bnft

2736: ecc.object_version_number
2737: from ben_elctbl_chc_ctfn ecc
2738: where enrt_bnft_id in
2739: (select enrt_bnft_id
2740: from ben_enrt_bnft
2741: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2742:
2743:
2744: cursor c_rate is

Line 2754: from ben_enrt_bnft

2750: from ben_elig_per_elctbl_chc
2751: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2752: or enrt_bnft_id in
2753: (select enrt_bnft_id
2754: from ben_enrt_bnft
2755: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2756: */
2757:
2758: select ecr.enrt_rt_id,

Line 2771: from ben_enrt_bnft

2767: ecr.object_version_number
2768: from ben_enrt_rt ecr
2769: where enrt_bnft_id in
2770: (select enrt_bnft_id
2771: from ben_enrt_bnft
2772: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2773:
2774:
2775: cursor c_bnft is

Line 2778: from ben_enrt_bnft enb

2774:
2775: cursor c_bnft is
2776: select enb.enrt_bnft_id,
2777: enb.object_version_number
2778: from ben_enrt_bnft enb
2779: where elig_per_elctbl_chc_id in
2780: (select elig_per_elctbl_chc_id
2781: from ben_elig_per_elctbl_chc
2782: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);

Line 2850: ben_enrt_bnft_api.delete_enrt_bnft

2846: end loop;
2847:
2848: -- Choice Benefits:
2849: for l_bnft in c_bnft loop
2850: ben_enrt_bnft_api.delete_enrt_bnft
2851: (p_validate => false,
2852: p_enrt_bnft_id => l_bnft.enrt_bnft_id,
2853: p_object_version_number => l_bnft.object_version_number,
2854: p_effective_date => p_effective_date);