DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PGM_F

Line 665: from ben_pgm_f

661: --
662: cursor dsgn_lvl_c
663: is
664: select dpnt_dsgn_lvl_cd
665: from ben_pgm_f
666: where pgm_id = p_pgm_id
667: and business_group_id = p_business_group_id
668: and p_effective_date between effective_start_date
669: and effective_end_date;

Line 676: from ben_pgm_f pgm

672: --
673: cursor c_dpnt_pgm
674: is
675: select pgm.dpnt_dsgn_no_ctfn_rqd_flag
676: from ben_pgm_f pgm
677: where pgm.pgm_id = p_pgm_id
678: and pgm.business_group_id = p_business_group_id
679: and p_effective_date between pgm.effective_start_date
680: and pgm.effective_end_date;