DBA Data[Home] [Help]

APPS.BEN_PUMP_GET dependencies on BEN_PGM_F

Line 152: from ben_pgm_f pgm

148: l_pgm_id := p_program_num ;
149: ELSIF p_program IS NOT NULL and p_program <> HR_API_G_VARCHAR2 THEN--Bug : 6652591
150: select pgm.pgm_id
151: into l_pgm_id
152: from ben_pgm_f pgm
153: where pgm.name = p_program
154: and pgm.business_group_id + 0 = p_business_group_id
155: and p_effective_date between
156: pgm.effective_start_date and pgm.effective_end_date;