DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PGM_F

Line 10742: from ben_pgm_f

10738: --
10739: cursor c_get_pgm_typ(cv_pgm_id in number,
10740: cv_effective_date in date ) is
10741: select pgm_typ_cd
10742: from ben_pgm_f
10743: where pgm_id = cv_pgm_id
10744: and cv_effective_date between effective_start_date
10745: and effective_end_date;
10746: --

Line 10757: l_pgm_rec ben_pgm_f%ROWTYPE;

10753: and effective_end_date;
10754: --
10755: l_package VARCHAR2(80) := g_package || '.derive_rate_and_factors';
10756: --
10757: l_pgm_rec ben_pgm_f%ROWTYPE;
10758: l_ptip_rec ben_ptip_f%ROWTYPE;
10759: l_comp_rec g_cache_structure;
10760: l_oiplip_rec g_cache_structure;
10761: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;