APPS.PQH_CPD_BUS dependencies on BEN_PGM_F

Line 798: FROM ben_pgm_f

794: PROCEDURE chk_ben_pgm_id(p_ben_pgm_id NUMBER,
795: p_effective_date DATE) is
796: CURSOR csr_ben_pgm_exists IS
797: SELECT 'Y'
798: FROM ben_pgm_f
799: WHERE pgm_id = p_ben_pgm_id
800: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
801:
802: l_valid varchar2(1) := 'N';