APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PL_REGN_F

Line 4718: from ben_pl_regn_f prg

4714: and pdp.effective_end_date = hr_api.g_eot;
4715: --
4716: cursor c2(p_pl_id in number) is
4717: select null
4718: from ben_pl_regn_f prg
4719: ,ben_regn_f reg
4720: where prg.pl_id = p_pl_id
4721: and prg.regn_id = reg.regn_id
4722: and reg.sttry_citn_name = 'COBRA'

Line 5078: from ben_pl_regn_f prg,

5074: and epo.effective_end_date
5075: and epo.elig_flag = 'Y'
5076: and ( c_only_pls_subj_cobra_flag = 'N'
5077: or exists (select null
5078: from ben_pl_regn_f prg,
5079: ben_regn_f reg
5080: where prg.pl_id = pln.pl_id
5081: and c_effective_date between prg.effective_start_date
5082: and prg.effective_end_date

Line 5101: ben_pl_regn_f prg,

5097: null
5098: from ben_pl_f pln,
5099: ben_plip_f cpp,
5100: ben_ptip_f ctp,
5101: ben_pl_regn_f prg,
5102: ben_regn_f reg,
5103: ben_elig_per_f epo,
5104: ben_per_in_ler pil
5105: where pln.pl_id = cpp.pl_id

Line 5131: from ben_pl_regn_f prg,

5127: and epo.effective_end_date
5128: and epo.elig_flag = 'Y'
5129: and ( c_only_pls_subj_cobra_flag = 'N' -- cobra regulation needed only when the flag is set
5130: or exists (select null
5131: from ben_pl_regn_f prg,
5132: ben_regn_f reg
5133: where prg.pl_id = pln.pl_id
5134: and c_effective_date between prg.effective_start_date
5135: and prg.effective_end_date

Line 5534: ben_pl_regn_f prg,

5530: --
5531: cursor c1(p_pl_id in number) is
5532: select null
5533: from ben_pl_f pln,
5534: ben_pl_regn_f prg,
5535: ben_regn_f reg
5536: where pln.pl_id = p_pl_id
5537: and pln.business_group_id = p_business_group_id
5538: and l_date_to_use