APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_LEE_RSN_F

Line 683: update ben_lee_rsn_f

679: p_oper_code => 'PROG');
680: hr_utility.set_location('prog le is'||l_ler_id,2);
681: if l_ler_id is not null then
682: begin
683: update ben_lee_rsn_f
684: set ENRT_CVG_STRT_DT_CD = p_pro_cvg_st_dt,
685: RT_STRT_DT_CD = p_pro_rt_st_dt
686: where POPL_ENRT_TYP_CYCL_ID = l_pet_id
687: and ler_id = l_ler_id

Line 709: update ben_lee_rsn_f

705: p_oper_code => 'SYNC');
706: hr_utility.set_location('sync le is'||l_ler_id,2);
707: if l_ler_id is not null then
708: begin
709: update ben_lee_rsn_f
710: set ENRT_CVG_STRT_DT_CD = p_syn_rt_st_dt,
711: RT_STRT_DT_CD = p_syn_rt_st_dt
712: where POPL_ENRT_TYP_CYCL_ID = l_pet_id
713: and ler_id = l_ler_id

Line 748: hr_utility.set_location(' BEN_LEE_RSN_F CREATE_LIFE_EVENT_ENROLL_RSN ',20);

744: l_ler_id := get_gsp_le (p_bg_id => p_bg_id,
745: p_effective_date => p_effective_date,
746: p_oper_code => 'PROG');
747: if l_ler_id is not null and p_pet_id is not null then
748: hr_utility.set_location(' BEN_LEE_RSN_F CREATE_LIFE_EVENT_ENROLL_RSN ',20);
749: BEN_LIFE_EVENT_ENROLL_RSN_API.CREATE_LIFE_EVENT_ENROLL_RSN(
750: P_EFFECTIVE_DATE => p_effective_date
751: ,P_BUSINESS_GROUP_ID => p_bg_id
752: ,P_LEE_RSN_ID => p_lee_rsn_id

Line 771: hr_utility.set_location(' BEN_LEE_RSN_F CREATE_LIFE_EVENT_ENROLL_RSN ',20);

767: l_ler_id := get_gsp_le (p_bg_id => p_bg_id,
768: p_effective_date => p_effective_date,
769: p_oper_code => 'SYNC');
770: if l_ler_id is not null and p_pet_id is not null then
771: hr_utility.set_location(' BEN_LEE_RSN_F CREATE_LIFE_EVENT_ENROLL_RSN ',20);
772: BEN_LIFE_EVENT_ENROLL_RSN_API.CREATE_LIFE_EVENT_ENROLL_RSN(
773: P_EFFECTIVE_DATE => p_effective_date
774: ,P_BUSINESS_GROUP_ID => p_bg_id
775: ,P_LEE_RSN_ID => p_lee_rsn_id

Line 3700: FROM ben_lee_rsn_f

3696:
3697: CURSOR csr_lee_rsns (p_popl_enrt_typ_cycl_id IN NUMBER)
3698: IS
3699: SELECT NULL
3700: FROM ben_lee_rsn_f
3701: WHERE ler_id = p_ler_id
3702: AND business_group_id = p_business_group_id
3703: AND popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id;
3704: BEGIN