APPS.BEN_CTP_BUS dependencies on BEN_PTIP_F

Line 51: from ben_ptip_f

47: is
48: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
49: l_dummy char(1);
50: cursor c1 is select null
51: from ben_ptip_f
52: where ptip_id <> nvl(p_ptip_id, -1 )
53: and pgm_id = p_pgm_id
54: and ordr_num = p_ordr_num
55: and business_group_id + 0 = p_business_group_id

Line 115: from ben_ptip_f

111: is
112: l_proc varchar2(72) := g_package||' chk_dup_pl_typ_id_in_pgm ';
113: l_dummy char(1);
114: cursor c1 is select null
115: from ben_ptip_f
116: where pgm_id = p_pgm_id
117: and business_group_id + 0 = p_business_group_id
118: and pl_typ_id = p_pl_typ_id
119: and ptip_id <> nvl(p_ptip_id, -1)

Line 5999: ben_ptip_f b

5995: --
5996: cursor csr_leg_code is
5997: select a.legislation_code
5998: from per_business_groups a,
5999: ben_ptip_f b
6000: where b.ptip_id = p_ptip_id
6001: and a.business_group_id = b.business_group_id;
6002: --
6003: -- Declare local variables