APPS.HR_CHANGE_START_DATE_API dependencies on BEN_ENRT_RT

Line 1153: Cursor c_ben_enrt_rt_GSP(cl_elig_per_elctbl_chc_id number) is

1149: and bepec.business_group_id = cl_business_group_id
1150: and bepec.per_in_ler_id = cl_per_in_ler_id
1151: and bpecp.per_in_ler_id = cl_per_in_ler_id;
1152:
1153: Cursor c_ben_enrt_rt_GSP(cl_elig_per_elctbl_chc_id number) is
1154: select enrt_rt_id,
1155: object_version_number
1156: from ben_enrt_rt
1157: where elig_per_elctbl_chc_id = cl_elig_per_elctbl_chc_id;

Line 1156: from ben_enrt_rt

1152:
1153: Cursor c_ben_enrt_rt_GSP(cl_elig_per_elctbl_chc_id number) is
1154: select enrt_rt_id,
1155: object_version_number
1156: from ben_enrt_rt
1157: where elig_per_elctbl_chc_id = cl_elig_per_elctbl_chc_id;
1158:
1159: l_bg_id Per_All_Assignments_F.Business_Group_id%TYPE;
1160: l_New_Enrlmt_Dt Date;

Line 1176: l_ENRT_RT_ID ben_enrt_rt.ENRT_RT_ID%type;

1172:
1173: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1174: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1175:
1176: l_ENRT_RT_ID ben_enrt_rt.ENRT_RT_ID%type;
1177: l_enrt_rt_ovn ben_enrt_rt.object_version_number%type;
1178:
1179: l_proc varchar2(100):= g_package||'.update_ben_GSP_enteries';
1180: begin

Line 1177: l_enrt_rt_ovn ben_enrt_rt.object_version_number%type;

1173: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;
1174: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;
1175:
1176: l_ENRT_RT_ID ben_enrt_rt.ENRT_RT_ID%type;
1177: l_enrt_rt_ovn ben_enrt_rt.object_version_number%type;
1178:
1179: l_proc varchar2(100):= g_package||'.update_ben_GSP_enteries';
1180: begin
1181:

Line 1216: for l_ben_enrt_rt_id in c_ben_enrt_rt_GSP(l_elig_per_elctbl_chc_id)

1212: --
1213: l_elig_per_elctbl_chc_id := l_ben_per_elctbl_chc_GSP.elig_per_elctbl_chc_id;
1214: l_Elctbl_Ovn := l_ben_per_elctbl_chc_GSP.object_version_number;
1215:
1216: for l_ben_enrt_rt_id in c_ben_enrt_rt_GSP(l_elig_per_elctbl_chc_id)
1217: loop
1218: --
1219: l_enrt_rt_id := l_ben_enrt_rt_id.enrt_rt_id;
1220: l_enrt_rt_ovn := l_ben_enrt_rt_id.object_version_number;

Line 1219: l_enrt_rt_id := l_ben_enrt_rt_id.enrt_rt_id;

1215:
1216: for l_ben_enrt_rt_id in c_ben_enrt_rt_GSP(l_elig_per_elctbl_chc_id)
1217: loop
1218: --
1219: l_enrt_rt_id := l_ben_enrt_rt_id.enrt_rt_id;
1220: l_enrt_rt_ovn := l_ben_enrt_rt_id.object_version_number;
1221:
1222: hr_utility.set_location('Processing BEN Rate:'|| l_enrt_rt_id, 30);
1223:

Line 1220: l_enrt_rt_ovn := l_ben_enrt_rt_id.object_version_number;

1216: for l_ben_enrt_rt_id in c_ben_enrt_rt_GSP(l_elig_per_elctbl_chc_id)
1217: loop
1218: --
1219: l_enrt_rt_id := l_ben_enrt_rt_id.enrt_rt_id;
1220: l_enrt_rt_ovn := l_ben_enrt_rt_id.object_version_number;
1221:
1222: hr_utility.set_location('Processing BEN Rate:'|| l_enrt_rt_id, 30);
1223:
1224: ben_Enrollment_Rate_api.update_Enrollment_Rate