APPS.HR_CHANGE_START_DATE_API dependencies on BEN_PTNL_LER_FOR_PER

Line 1054: FROM ben_ptnl_ler_for_per bplfp, ben_ler_f blf

1050: and p_new_start_date between effective_start_date and effective_end_date;
1051:
1052: cursor c_ben_non_GSP(cl_business_group_id number, cl_start_date date, cl_end_date date) is
1053: SELECT 1
1054: FROM ben_ptnl_ler_for_per bplfp, ben_ler_f blf
1055: where blf.ler_id = bplfp.ler_id
1056: and blf.typ_cd <> 'GSP'
1057: and blf.business_group_id = cl_business_group_id
1058: and bplfp.business_group_id = cl_business_group_id

Line 1125: FROM ben_ptnl_ler_for_per bplfp,

1121:
1122: cursor c_ben_ptnl_ler_GSP(cl_business_group_id number, cl_start_date date, cl_end_date date) is
1123: SELECT bplfp.ptnl_ler_for_per_id,
1124: bplfp.object_version_number
1125: FROM ben_ptnl_ler_for_per bplfp,
1126: ben_ler_f blf
1127: where blf.ler_id = bplfp.ler_id
1128: and blf.typ_cd = 'GSP'
1129: and blf.business_group_id = cl_business_group_id

Line 1164: l_ptnl_ler_for_per_id Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

1160: l_New_Enrlmt_Dt Date;
1161: l_start_date Date;
1162: l_end_date Date;
1163:
1164: l_ptnl_ler_for_per_id Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1165: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1166:
1167: l_per_in_ler_id Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1168: l_procd_dt Date;

Line 1165: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;

1161: l_start_date Date;
1162: l_end_date Date;
1163:
1164: l_ptnl_ler_for_per_id Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1165: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1166:
1167: l_per_in_ler_id Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1168: l_procd_dt Date;
1169: l_strtd_dt Date;

Line 1268: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1264: end loop;
1265:
1266: hr_utility.set_location('Processing Potential Person Life Event:'|| l_per_in_ler_id, 60);
1267:
1268: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1269: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
1270: ,p_lf_evt_ocrd_dt => l_new_Enrlmt_Dt
1271: ,p_object_version_number => l_Ptnl_Ovn
1272: ,p_effective_date => l_new_Enrlmt_Dt);