APPS.PQH_GSP_DEFAULT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 147: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

143: l_electbl_chc_id number;
144: begin
145: select epe.ELIG_PER_ELCTBL_CHC_ID
146: into l_electbl_chc_id
147: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
148: where pil.per_in_ler_id = epe.per_in_ler_id
149: and pil.per_in_ler_id = p_per_in_ler_id
150: and pil.per_in_ler_stat_cd = 'STRTD'
151: and epe.comp_lvl_cd ='OIPL'

Line 169: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

165: l_electbl_chc_id number;
166: begin
167: select epe.ELIG_PER_ELCTBL_CHC_ID
168: into l_electbl_chc_id
169: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
170: where pil.per_in_ler_id = epe.per_in_ler_id
171: and pil.per_in_ler_id = p_per_in_ler_id
172: and pil.per_in_ler_stat_cd = 'STRTD'
173: and epe.comp_lvl_cd ='PLAN'

Line 1209: Ben_Elig_Per_Elctbl_Chc ELctbl,

1205: Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id
1206: from Per_all_Assignments_F Asgt,
1207: Ben_Per_In_Ler Pler,
1208: Ben_Ler_F Ler,
1209: Ben_Elig_Per_Elctbl_Chc ELctbl,
1210: Ben_Enrt_Rt Rt
1211: Where Asgt.Assignment_Id = P_Assignment_id
1212: and P_Effective_Date
1213: Between Asgt.Effective_Start_Date