DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PL_TYP_F

Line 1380: from BEN_PL_F pln, BEN_PL_TYP_f opt

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