DBA Data[Home] [Help]

APPS.BEN_PBB_BUS dependencies on BEN_PER_BNFTS_BAL_F

Line 117: from ben_per_bnfts_bal_f

113: --
114: l_proc varchar2(72) := g_package||'chk_per_bnft_bal_unique';
115: v_dummy varchar2(1);
116: cursor c1 is select null
117: from ben_per_bnfts_bal_f
118: where per_bnfts_bal_id <> nvl(p_per_bnfts_bal_id, -1)
119: and (person_id = p_person_id
120: and
121: bnfts_bal_id = p_bnfts_bal_id)

Line 471: ben_per_bnfts_bal_f b

467: --
468: cursor csr_leg_code is
469: select a.legislation_code
470: from per_business_groups a,
471: ben_per_bnfts_bal_f b
472: where b.per_bnfts_bal_id = p_per_bnfts_bal_id
473: and a.business_group_id = b.business_group_id;
474: --
475: -- Declare local variables