APPS.BEN_PAP_BUS dependencies on BEN_PRTT_ANTHR_PL_RT_F

Line 126: from ben_prtt_anthr_pl_rt_f

122: l_exists varchar2(1);
123: --
124: cursor c_dup is
125: select null
126: from ben_prtt_anthr_pl_rt_f
127: where pl_id = p_pl_id
128: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
129: and prtt_anthr_pl_rt_id <> nvl(p_prtt_anthr_pl_rt_id,hr_api.g_number)
130: and business_group_id + 0 = p_business_group_id

Line 278: from ben_prtt_anthr_pl_rt_f

274: is
275: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
276: l_dummy char(1);
277: cursor c1 is select null
278: from ben_prtt_anthr_pl_rt_f
279: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
280: -- changed against bug: 5113011
281: and prtt_anthr_pl_rt_id <> nvl(p_prtt_anthr_pl_rt_id ,-1)
282: -- and pl_id <> nvl(p_pl_id ,-1)

Line 665: ben_prtt_anthr_pl_rt_f b

661: --
662: cursor csr_leg_code is
663: select a.legislation_code
664: from per_business_groups a,
665: ben_prtt_anthr_pl_rt_f b
666: where b.prtt_anthr_pl_rt_id = p_prtt_anthr_pl_rt_id
667: and a.business_group_id = b.business_group_id;
668: --
669: -- Declare local variables