DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PGM_F

Line 813: from ben_pgm_f

809: --
810: cursor dsgn_lvl_c
811: is
812: select dpnt_dsgn_lvl_cd
813: from ben_pgm_f
814: where pgm_id = p_pgm_id
815: and business_group_id = p_business_group_id
816: and p_effective_date between effective_start_date
817: and effective_end_date;

Line 824: from ben_pgm_f pgm

820: --
821: cursor c_dpnt_pgm
822: is
823: select pgm.dpnt_dsgn_no_ctfn_rqd_flag
824: from ben_pgm_f pgm
825: where pgm.pgm_id = p_pgm_id
826: and pgm.business_group_id = p_business_group_id
827: and p_effective_date between pgm.effective_start_date
828: and pgm.effective_end_date;