APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ELCTBL_CHC_CTFN

Line 2717: from ben_elctbl_chc_ctfn ecc

2713:
2714: cursor c_ctfn is
2715: /* select ecc.elctbl_chc_ctfn_id,
2716: ecc.object_version_number
2717: from ben_elctbl_chc_ctfn ecc
2718: where elig_per_elctbl_chc_id in
2719: (select elig_per_elctbl_chc_id
2720: from ben_elig_per_elctbl_chc
2721: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2729: from ben_elctbl_chc_ctfn ecc

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
2729: from ben_elctbl_chc_ctfn ecc
2730: where elig_per_elctbl_chc_id in
2731: (select elig_per_elctbl_chc_id
2732: from ben_elig_per_elctbl_chc
2733: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2737: from ben_elctbl_chc_ctfn ecc

2733: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2734: UNION
2735: select ecc.elctbl_chc_ctfn_id,
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);

Line 2832: -- ben_elctbl_chc_ctfn_api.delete_elctbl_chc_ctfn

2828:
2829: -- Choice Certification:
2830: for l_ctfn in c_ctfn loop
2831: null; -- api does not exist yet!
2832: -- ben_elctbl_chc_ctfn_api.delete_elctbl_chc_ctfn
2833: -- (p_validate => false,
2834: -- p_enrt_cvg_n_rt_ctfn_id => l_ctfn.enrt_cvg_n_rt_ctfn_id,
2835: -- p_object_version_number => l_ctfn.object_version_number,
2836: -- p_effective_date => p_effective_date);