APPS.BEN_PRTT_RMT_APRVD_PYMT_API dependencies on BEN_PGM_F
Line 167: from ben_pgm_f pgm
163: cursor c_pgm
164: (c_pgm_id number)
165: is
166: select pgm.acty_ref_perd_cd 167: from ben_pgm_f pgm 168: where pgm.pgm_id = c_pgm_id
169: and p_effective_date
170: between pgm.effective_start_date
171: and pgm.effective_end_date;