APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ELCTBL_CHC_CTFN

Line 2722: from ben_elctbl_chc_ctfn ecc

2718:
2719: cursor c_ctfn is
2720: /* select ecc.elctbl_chc_ctfn_id,
2721: ecc.object_version_number
2722: from ben_elctbl_chc_ctfn ecc
2723: where elig_per_elctbl_chc_id in
2724: (select elig_per_elctbl_chc_id
2725: from ben_elig_per_elctbl_chc
2726: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2734: from ben_elctbl_chc_ctfn ecc

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
2734: from ben_elctbl_chc_ctfn ecc
2735: where elig_per_elctbl_chc_id in
2736: (select elig_per_elctbl_chc_id
2737: from ben_elig_per_elctbl_chc
2738: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2742: from ben_elctbl_chc_ctfn ecc

2738: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2739: UNION
2740: select ecc.elctbl_chc_ctfn_id,
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);

Line 2837: -- ben_elctbl_chc_ctfn_api.delete_elctbl_chc_ctfn

2833:
2834: -- Choice Certification:
2835: for l_ctfn in c_ctfn loop
2836: null; -- api does not exist yet!
2837: -- ben_elctbl_chc_ctfn_api.delete_elctbl_chc_ctfn
2838: -- (p_validate => false,
2839: -- p_enrt_cvg_n_rt_ctfn_id => l_ctfn.enrt_cvg_n_rt_ctfn_id,
2840: -- p_object_version_number => l_ctfn.object_version_number,
2841: -- p_effective_date => p_effective_date);