DBA Data[Home] [Help]

APPS.GHR_TSP_PLAN_DESIGN dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 302: from ben_elig_per_ELCTBL_chc chc ,

298:
299: Cursor c_get_elig_chc_id is
300: select elig_per_elctbl_chc_id,
301: pil.per_in_ler_id
302: from ben_elig_per_ELCTBL_chc chc ,
303: ben_per_in_ler pil
304: where chc.pgm_id = p_pgm_id
305: and chc.pl_typ_id = get_ee_last_tsp_enrt_rec.pl_typ_id
306: and chc.pl_id = get_ee_last_tsp_enrt_rec.pl_id