APPS.BEN_APR_BUS dependencies on BEN_OIPL_F

Line 136: ben_oipl_f cop

132: cursor c2 is
133: select null
134: from hr_all_organization_units org,
135: ben_popl_org_f pop,
136: ben_oipl_f cop
137: where org.organization_id = p_organization_id
138: and pop.organization_id = org.organization_id
139: and cop.oipl_id = p_oipl_id
140: and cop.pl_id = pop.pl_id

Line 2115: (p_base_table_name => 'ben_oipl_f',

2111: p_argument => 'actl_prem_id',
2112: p_argument_value => p_actl_prem_id);
2113: --
2114: If (dt_api.rows_exist
2115: (p_base_table_name => 'ben_oipl_f',
2116: p_base_key_column => 'actl_prem_id',
2117: p_base_key_value => p_actl_prem_id,
2118: p_from_date => p_validation_start_date,
2119: p_to_date => p_validation_end_date)) Then

Line 2120: l_table_name := 'ben_oipl_f';

2116: p_base_key_column => 'actl_prem_id',
2117: p_base_key_value => p_actl_prem_id,
2118: p_from_date => p_validation_start_date,
2119: p_to_date => p_validation_end_date)) Then
2120: l_table_name := 'ben_oipl_f';
2121: Raise l_rows_exist;
2122: End If;
2123: If (dt_api.rows_exist
2124: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',

Line 2214: -- Bug 2695254 changed the ben_pl to ben_pl_f and ben_oipl to ben_oipl_f

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
2217: select cvg.name
2218: from ben_pl_f coa,ben_cvg_amt_calc_mthd_f cvg

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: