DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_POPL_ACTN_TYP_F

Line 609: from ben_popl_actn_typ_f pat

605: pat.effective_start_date,
606: pat.effective_end_date,
607: pat.actn_typ_due_dt_cd,
608: pat.actn_typ_due_dt_rl
609: from ben_popl_actn_typ_f pat
610: where pat.pl_id = v_pl_id
611: and pat.actn_typ_id = p_actn_typ_id
612: and pat.business_group_id = p_business_group_id
613: and p_effective_date between pat.effective_start_date

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.pgm_id = v_pgm_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 7409: from ben_popl_actn_typ_f pat,

7405: -- for beneficiary related action types.
7406: --
7407: cursor c_bnf_actn_item is
7408: select null
7409: from ben_popl_actn_typ_f pat,
7410: ben_actn_typ eat
7411: where pat.pl_id = p_pl_id
7412: and pat.actn_typ_id = eat.actn_typ_id
7413: and eat.type_cd = p_actn_type_cd