APPS.BEN_APR_BUS dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 2212: l_dummy ben_cvg_amt_calc_mthd_f.name%type := null; --UTF8 Change Bug 2254683

2208: p_object_version_number in number
2209: ) is
2210: l_proc varchar2(72) := g_package||'chk_mlt_cd_dependencies';
2211: l_api_updating boolean;
2212: l_dummy ben_cvg_amt_calc_mthd_f.name%type := null; --UTF8 Change Bug 2254683
2213: --
2214: -- Bug 2695254 changed the ben_pl to ben_pl_f and ben_oipl to ben_oipl_f
2215: --
2216: cursor c1 is

Line 2218: from ben_pl_f coa,ben_cvg_amt_calc_mthd_f cvg

2214: -- Bug 2695254 changed the ben_pl to ben_pl_f and ben_oipl to ben_oipl_f
2215: --
2216: cursor c1 is
2217: select cvg.name
2218: from ben_pl_f coa,ben_cvg_amt_calc_mthd_f cvg
2219: where coa.pl_id = p_pl_id
2220: and coa.pl_id = cvg.pl_id (+)
2221: and coa.business_group_id = p_business_group_id
2222: union

Line 2224: from ben_oipl_f coa,ben_cvg_amt_calc_mthd_f cvg

2220: and coa.pl_id = cvg.pl_id (+)
2221: and coa.business_group_id = p_business_group_id
2222: union
2223: select cvg.name
2224: from ben_oipl_f coa,ben_cvg_amt_calc_mthd_f cvg
2225: where coa.oipl_id = p_oipl_id
2226: and coa.oipl_id = cvg.oipl_id (+)
2227: and coa.business_group_id = p_business_group_id;
2228: