APPS.HR_CHANGE_START_DATE_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1146: from ben_elig_per_elctbl_chc bepec, ben_pil_elctbl_chc_popl bpecp

1142:
1143: Cursor c_ben_per_elctbl_chc_GSP(cl_business_group_id number, cl_per_in_ler_id number) is
1144: select bepec.elig_per_elctbl_chc_id,
1145: bepec.object_version_number
1146: from ben_elig_per_elctbl_chc bepec, ben_pil_elctbl_chc_popl bpecp
1147: where bpecp.pil_elctbl_chc_popl_id = bepec.pil_elctbl_chc_popl_id
1148: and bpecp.business_group_id = cl_business_group_id
1149: and bepec.business_group_id = cl_business_group_id
1150: and bepec.per_in_ler_id = cl_per_in_ler_id

Line 1173: L_Elig_Per_Elctbl_Chc_Id Ben_Elig_Per_Elctbl_Chc.Elig_Per_Elctbl_Chc_Id%TYPE;

1169: l_strtd_dt Date;
1170: l_voidd_dt Date;
1171: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%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;

Line 1174: l_Elctbl_Ovn Ben_Elig_Per_Elctbl_Chc.Object_version_Number%TYPE;

1170: l_voidd_dt Date;
1171: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%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: