APPS.BEN_CCM_BUS dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 118: from ben_cvg_amt_calc_mthd_F

114: --
115: cursor c_creation_date
116: is
117: select min(creation_date)
118: from ben_cvg_amt_calc_mthd_F
119: where cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id;
120: --
121: begin
122: --

Line 329: ben_ccm_shd.constraint_error('BEN_CVG_AMT_CALC_MTHD_FK2');

325: --
326: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
327: -- table.
328: --
329: ben_ccm_shd.constraint_error('BEN_CVG_AMT_CALC_MTHD_FK2');
330: --
331: end if;
332: --
333: close c1;

Line 1761: from ben_cvg_amt_calc_mthd_f

1757: is
1758: l_proc varchar2(72) := g_package||'chk_oipl_id_unique';
1759: l_dummy char(1);
1760: cursor c1 is select null
1761: from ben_cvg_amt_calc_mthd_f
1762: Where cvg_amt_calc_mthd_id <> nvl(p_cvg_amt_calc_mthd_id,-1)
1763: and oipl_id = p_oipl_id
1764: and business_group_id = p_business_group_id
1765: and p_effective_date between effective_start_date

Line 1819: from ben_cvg_amt_calc_mthd_f

1815: is
1816: l_proc varchar2(72) := g_package||'chk_pl_id_unique';
1817: l_dummy char(1);
1818: cursor c1 is select null
1819: from ben_cvg_amt_calc_mthd_f
1820: Where cvg_amt_calc_mthd_id <> nvl(p_cvg_amt_calc_mthd_id,-1)
1821: and pl_id = p_pl_id
1822: and business_group_id = p_business_group_id
1823: and p_effective_date between effective_start_date

Line 3034: ben_cvg_amt_calc_mthd_f b

3030: --
3031: cursor csr_leg_code is
3032: select a.legislation_code
3033: from per_business_groups a,
3034: ben_cvg_amt_calc_mthd_f b
3035: where b.cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
3036: and a.business_group_id = b.business_group_id;
3037: --
3038: -- Declare local variables