DBA Data[Home] [Help]

APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on HRI_CS_TIME_BENRL_PRD_CT

Line 649: hri_cs_time_benrl_prd_ct enpd

645: ,pelq.per_in_ler_id per_in_ler_id
646: ,pelq.pgm_id pgm_id
647: ,pelq.pil_elctbl_chc_popl_id pil_elctbl_chc_popl_id
648: FROM hri_eq_ben_elctn_evts pelq,
649: hri_cs_time_benrl_prd_ct enpd
650: WHERE pelq.pil_elctbl_popl_stat_cd IN ('STRTD','PROCD')
651: AND pelq.event_cd = 'UPDATE'
652: AND pelq.per_in_ler_id = p_per_in_ler_id
653: AND pelq.person_id = p_person_id

Line 908: hri_cs_time_benrl_prd_ct enpd,

904: OR (opt.opt_id IS NULL AND pln.invk_dcln_prtn_pl_flag = 'Y')) )
905: THEN 1
906: ELSE 0 END ) waive_dflt_ind
907: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq,
908: hri_cs_time_benrl_prd_ct enpd,
909: hri_cs_compobj_ct copd,
910: ben_opt_f opt,
911: ben_pl_f pln
912: WHERE penq.per_in_ler_id = p_per_in_ler_id