DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 198: from ben_pil_elctbl_chc_popl pel

194: --
195: cursor c_pel_pgm_id is
196: --
197: select pel.*
198: from ben_pil_elctbl_chc_popl pel
199: where pel.per_in_ler_id = p_per_in_ler_id
200: and pel.defer_deenrol_flag = 'Y'
201: and pel.deenrol_made_dt is null
202: and pel.pil_elctbl_popl_stat_cd not in ('VOIDD','BCKDT');

Line 381: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

377: end loop;
378: --
379: close c_epo_plip_defer;
380: --
381: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
382: (p_validate => FALSE
383: ,p_pil_elctbl_chc_popl_id => l_pel_pgm_id.pil_elctbl_chc_popl_id
384: ,p_object_version_number => l_pel_pgm_id.object_version_number
385: ,p_effective_date => p_effective_date

Line 454: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

450: end loop;
451: --
452: close c_epo_plnip_defer;
453: --
454: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
455: (p_validate => FALSE
456: ,p_pil_elctbl_chc_popl_id => l_pel_pgm_id.pil_elctbl_chc_popl_id
457: ,p_object_version_number => l_pel_pgm_id.object_version_number
458: ,p_effective_date => p_effective_date