DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_REGN_F

Line 6889: ben_regn_f reg

6885: cursor c1(p_pl_id in number,p_date_to_use date ) is
6886: select null
6887: from ben_pl_f pln,
6888: ben_pl_regn_f prg,
6889: ben_regn_f reg
6890: where pln.pl_id = p_pl_id
6891: and pln.business_group_id = p_business_group_id
6892: and p_date_to_use
6893: between pln.effective_start_date

Line 7099: ,ben_regn_f reg

7095: --
7096: cursor c2(p_pl_id in number,p_date_to_use date ) is
7097: select null
7098: from ben_pl_regn_f prg
7099: ,ben_regn_f reg
7100: where prg.pl_id = p_pl_id
7101: and prg.regn_id = reg.regn_id
7102: and reg.sttry_citn_name = 'COBRA'
7103: and prg.business_group_id = p_business_group_id