DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PL_REGN_F

Line 6876: ben_pl_regn_f prg,

6872: --
6873: cursor c1(p_pl_id in number,p_date_to_use date ) is
6874: select null
6875: from ben_pl_f pln,
6876: ben_pl_regn_f prg,
6877: ben_regn_f reg
6878: where pln.pl_id = p_pl_id
6879: and pln.business_group_id = p_business_group_id
6880: and p_date_to_use

Line 7086: from ben_pl_regn_f prg

7082: and pdp.effective_end_date = hr_api.g_eot;
7083: --
7084: cursor c2(p_pl_id in number,p_date_to_use date ) is
7085: select null
7086: from ben_pl_regn_f prg
7087: ,ben_regn_f reg
7088: where prg.pl_id = p_pl_id
7089: and prg.regn_id = reg.regn_id
7090: and reg.sttry_citn_name = 'COBRA'