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 3693: FROM ben_popl_enrt_typ_cycl_f

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