DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 200: from ben_pil_elctbl_chc_popl pel

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

Line 383: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

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

Line 456: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

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