672:
673: cursor c_ptip_fd ( l_pgm_id number ,
674: l_pl_typ_id number ) is
675: select short_name , short_code 676: from ben_ptip_f ptip 677: where pl_typ_id = l_pl_typ_id
678: and pgm_id = l_pgm_id
679: and p_effective_date between nvl(ptip.effective_start_date, p_effective_date)
680: and nvl(ptip.effective_end_date, p_effective_date)