APPS.BEN_ELU_BUS dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 120: from ben_elig_lbr_mmbr_prte_f

116: l_exists varchar2(1);
117: --
118: cursor c3 is
119: select null
120: from ben_elig_lbr_mmbr_prte_f
121: where lbr_mmbr_flag = p_lbr_mmbr_flag
122: and eligy_prfl_id = p_eligy_prfl_id
123: and elig_lbr_mmbr_prte_id <> nvl(p_elig_lbr_mmbr_prte_id,hr_api.g_number)
124: and business_group_id + 0 = p_business_group_id

Line 286: from ben_elig_lbr_mmbr_prte_f

282: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
283: l_dummy char(1);
284: cursor c1 is
285: select null
286: from ben_elig_lbr_mmbr_prte_f
287: where elig_lbr_mmbr_prte_id <> nvl(p_elig_lbr_mmbr_prte_id,-1)
288: and eligy_prfl_id = p_eligy_prfl_id
289: and ordr_num = p_ordr_num
290: and business_group_id = p_business_group_id;

Line 648: ben_elig_lbr_mmbr_prte_f b

644: --
645: cursor csr_leg_code is
646: select a.legislation_code
647: from per_business_groups a,
648: ben_elig_lbr_mmbr_prte_f b
649: where b.elig_lbr_mmbr_prte_id = p_elig_lbr_mmbr_prte_id
650: and a.business_group_id = b.business_group_id;
651: --
652: -- Declare local variables