DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on BEN_PER_IN_LER

Line 297: ben_per_in_ler pil

293: Cursor get_elig_chc_id_opt is
294: select elig_per_elctbl_chc_id,
295: pil.per_in_ler_id
296: from ben_elig_per_ELCTBL_chc chc ,
297: ben_per_in_ler pil
298: where chc.pgm_id = l_pgm_id
299: and chc.pl_typ_id = l_pl_typ_id
300: and chc.pl_id = l_pl_id
301: and chc.plip_id = l_plip_id

Line 312: ben_per_in_ler pil

308: Cursor get_elig_chc_id is
309: select elig_per_elctbl_chc_id,
310: pil.per_in_ler_id
311: from ben_elig_per_ELCTBL_chc chc ,
312: ben_per_in_ler pil
313: where chc.pgm_id = l_pgm_id
314: and chc.pl_typ_id = l_pl_typ_id
315: and chc.pl_id = l_pl_id
316: and chc.plip_id = l_plip_id

Line 816: ben_per_in_ler pil

812: Cursor c_get_elig_chc_id_opt is
813: select elig_per_elctbl_chc_id,
814: pil.per_in_ler_id
815: from ben_elig_per_ELCTBL_chc chc ,
816: ben_per_in_ler pil
817: where chc.pgm_id = l_pgm_id
818: and chc.pl_typ_id = l_pl_typ_id
819: and chc.pl_id = l_pl_id
820: and chc.plip_id = l_plip_id

Line 1184: ben_per_in_ler pil

1180: Cursor c_get_elig_chc_id_opt is
1181: select elig_per_elctbl_chc_id,
1182: pil.per_in_ler_id
1183: from ben_elig_per_ELCTBL_chc chc ,
1184: ben_per_in_ler pil
1185: where chc.pgm_id = l_pgm_id
1186: and chc.pl_typ_id = l_pl_typ_id
1187: and chc.pl_id = l_pl_id
1188: and chc.plip_id = l_plip_id