eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_POPL_ACTN_TYP_F

Line 622: from ben_popl_actn_typ_f pat

618: pat.effective_start_date,
619: pat.effective_end_date,
620: pat.actn_typ_due_dt_cd,
621: pat.actn_typ_due_dt_rl
622: from ben_popl_actn_typ_f pat
623: where pat.pl_id = v_pl_id
624: and pat.actn_typ_id = p_actn_typ_id
625: and pat.business_group_id = p_business_group_id
626: and p_effective_date between pat.effective_start_date

Line 635: from ben_popl_actn_typ_f pat

631: pat.effective_start_date,
632: pat.effective_end_date,
633: pat.actn_typ_due_dt_cd,
634: pat.actn_typ_due_dt_rl
635: from ben_popl_actn_typ_f pat
636: where pat.pgm_id = v_pgm_id
637: and pat.actn_typ_id = p_actn_typ_id
638: and pat.business_group_id = p_business_group_id
639: and p_effective_date between pat.effective_start_date

Line 7494: from ben_popl_actn_typ_f pat,

7490: -- for beneficiary related action types.
7491: --
7492: cursor c_bnf_actn_item is
7493: select null
7494: from ben_popl_actn_typ_f pat,
7495: ben_actn_typ eat
7496: where pat.pl_id = p_pl_id
7497: and pat.actn_typ_id = eat.actn_typ_id
7498: and eat.type_cd = p_actn_type_cd