DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PL_TYP_F

Line 1379: from BEN_PL_F pln, BEN_PL_TYP_f opt

1375: l_stated_salary c_stated_salary%rowtype;
1376: --
1377: cursor c_opt_typ_cd (v_effective_date date) is
1378: select opt.OPT_TYP_CD
1379: from BEN_PL_F pln, BEN_PL_TYP_f opt
1380: where opt.pl_typ_id = pln.pl_typ_id
1381: and opt.OPT_TYP_CD = 'CWB'
1382: and v_effective_date
1383: between pln.effective_start_date