DBA Data[Home] [Help]

APPS.BEN_CER_BUS dependencies on BEN_PRTN_ELIGY_RL_F

Line 353: from ben_prtn_eligy_rl_f

349: is
350: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
351: l_dummy char(1);
352: cursor c1 is select null
353: from ben_prtn_eligy_rl_f
354: where prtn_eligy_rl_id <> nvl(p_prtn_eligy_rl_id, -1 )
355: and prtn_elig_id = p_prtn_elig_id
356: and ordr_to_aply_num = p_ordr_to_aply_num
357: and business_group_id + 0 = p_business_group_id

Line 847: ben_prtn_eligy_rl_f b

843: --
844: cursor csr_leg_code is
845: select a.legislation_code
846: from per_business_groups a,
847: ben_prtn_eligy_rl_f b
848: where b.prtn_eligy_rl_id = p_prtn_eligy_rl_id
849: and a.business_group_id = b.business_group_id;
850: --
851: -- Declare local variables