APPS.BEN_IRC_UTIL dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 540: FROM ben_pil_elctbl_chc_popl pel

536:
537: CURSOR c_pil_elctbl_chc_popl (p_per_in_ler_id NUMBER)
538: IS
539: SELECT pel.pil_elctbl_chc_popl_id, pel.object_version_number
540: FROM ben_pil_elctbl_chc_popl pel
541: WHERE pel.per_in_ler_id = p_per_in_ler_id;
542:
543: CURSOR c_latest_ler
544: IS

Line 665: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,

661: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
662: l_pel_object_version_number;
663: EXIT WHEN c_pil_elctbl_chc_popl%NOTFOUND;
664: --
665: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,
666: p_pil_elctbl_chc_popl_id => l_pel_pk_id,
667: p_pil_elctbl_popl_stat_cd => 'BCKDT',
668: p_object_version_number => l_pel_object_version_number,
669: p_effective_date => p_effective_date

Line 757: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,

753: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
754: l_pel_object_version_number;
755: EXIT WHEN c_pil_elctbl_chc_popl%NOTFOUND;
756: --
757: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,
758: p_pil_elctbl_chc_popl_id => l_pel_pk_id,
759: p_pil_elctbl_popl_stat_cd => 'BCKDT',
760: p_object_version_number => l_pel_object_version_number,
761: p_effective_date => p_effective_date

Line 863: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,

859: LOOP
860: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
861: l_pel_object_version_number;
862: EXIT WHEN c_pil_elctbl_chc_popl%NOTFOUND;
863: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl (p_validate => FALSE,
864: p_pil_elctbl_chc_popl_id => l_pel_pk_id,
865: p_pil_elctbl_popl_stat_cd => 'STRTD',
866: p_object_version_number => l_pel_object_version_number,
867: p_effective_date => p_effective_date