DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PL_REGN_F

Line 6888: ben_pl_regn_f prg,

6884: --
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

Line 7098: from ben_pl_regn_f prg

7094: and pdp.effective_end_date = hr_api.g_eot;
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'