APPS.BEN_EFP_BUS dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 190: from ben_elig_fl_tm_pt_tm_prte_f

186: --
187: --
188: cursor c3 is
189: select null
190: from ben_elig_fl_tm_pt_tm_prte_f
191: where fl_tm_pt_tm_cd = p_fl_tm_pt_tm_cd
192: and eligy_prfl_id = p_eligy_prfl_id
193: and elig_fl_tm_pt_tm_prte_id <> nvl(p_elig_fl_tm_pt_tm_prte_id,hr_api.g_number)
194: and business_group_id + 0 = p_business_group_id

Line 287: from ben_elig_fl_tm_pt_tm_prte_f

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

Line 656: ben_elig_fl_tm_pt_tm_prte_f b

652: --
653: cursor csr_leg_code is
654: select a.legislation_code
655: from per_business_groups a,
656: ben_elig_fl_tm_pt_tm_prte_f b
657: where b.elig_fl_tm_pt_tm_prte_id = p_elig_fl_tm_pt_tm_prte_id
658: and a.business_group_id = b.business_group_id;
659: --
660: -- Declare local variables