APPS.BEN_CPP_BUS dependencies on BEN_PLIP_F

Line 48: from ben_plip_f

44: is
45: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
46: l_dummy char(1);
47: cursor c1 is select null
48: from ben_plip_f
49: where plip_id <> nvl(p_plip_id,-1)
50: and pgm_id = p_pgm_id
51: and business_group_id + 0 = p_business_group_id
52: and ordr_num = p_ordr_num

Line 111: from ben_plip_f

107: l_proc varchar2(72) := g_package||' chk_duplicate_pl_id_in_pgm ';
108: l_dummy char(1);
109:
110: cursor c1 is select null
111: from ben_plip_f
112: where pgm_id = p_pgm_id
113: and business_group_id + 0 = p_business_group_id
114: and pl_id = p_pl_id
115: and plip_id <> nvl(p_plip_id, -1)

Line 2743: ben_plip_f plip

2739: and business_group_id +0 = p_business_group_id;
2740: --
2741: cursor count_plans is select count(distinct pl.pl_id)
2742: from ben_pl_f pl,
2743: ben_plip_f plip
2744: where plip.pgm_id = p_pgm_id
2745: and plip.pl_id = pl.pl_id
2746: and pl.imptd_incm_calc_cd = 'PRTT'
2747: and plip.plip_id <> nvl(p_plip_id, -1)

Line 2840: ben_plip_f plip

2836: and business_group_id = p_business_group_id;
2837: --
2838: cursor count_plans is select count(distinct pl.pl_id)
2839: from ben_pl_f pl,
2840: ben_plip_f plip
2841: where plip.pgm_id = p_pgm_id
2842: and plip.pl_id = pl.pl_id
2843: and pl.invk_flx_cr_pl_flag = 'Y'
2844: and plip.plip_id <> nvl(p_plip_id, -1)

Line 4133: from ben_plip_f

4129: l_pl_id number;
4130: l_pgm_id number;
4131:
4132: cursor c2 is select pgm_id,pl_id
4133: from ben_plip_f
4134: where plip_id =p_plip_id
4135: and p_effective_date between effective_start_date
4136: and effective_end_date;
4137:

Line 5254: ben_plip_f b

5250: --
5251: cursor csr_leg_code is
5252: select a.legislation_code
5253: from per_business_groups a,
5254: ben_plip_f b
5255: where b.plip_id = p_plip_id
5256: and a.business_group_id = b.business_group_id;
5257: --
5258: -- Declare local variables