APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 633: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F CREATE_POPL_ENRT_TYP_CYCL ',20);

629: l_eed date;
630: l_pet_id number;
631: begin
632: hr_utility.set_location('creating pet for pgm'||p_pgm_id,1);
633: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F CREATE_POPL_ENRT_TYP_CYCL ',20);
634: BEN_POPL_ENRT_TYP_CYCL_API.CREATE_POPL_ENRT_TYP_CYCL(
635: P_EFFECTIVE_DATE => p_effective_date
636: ,P_BUSINESS_GROUP_ID => p_bg_id
637: ,P_ENRT_TYP_CYCL_CD => 'L'

Line 661: from ben_popl_enrt_typ_cycl_f

657: hr_utility.set_location('updating le_enrl for pgm'||p_pgm_id,1);
658: begin
659: select popl_enrt_typ_cycl_id
660: into l_pet_id
661: from ben_popl_enrt_typ_cycl_f
662: where pgm_id = p_pgm_id
663: and p_effective_date between effective_start_date and effective_end_date;
664: hr_utility.set_location('pet is'||l_pet_id,2);
665: exception

Line 3694: FROM ben_popl_enrt_typ_cycl_f

3690:
3691: CURSOR csr_pgm_enrl (p_pgm_id IN NUMBER)
3692: IS
3693: SELECT popl_enrt_typ_cycl_id
3694: FROM ben_popl_enrt_typ_cycl_f
3695: WHERE pgm_id = p_pgm_id;
3696:
3697: CURSOR csr_lee_rsns (p_popl_enrt_typ_cycl_id IN NUMBER)
3698: IS