APPS.BEN_EHW_BUS dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 127: from ben_elig_hrs_wkd_prte_f

123: and a.business_group_id + 0 = p_business_group_id;
124: --
125: cursor c3 is
126: select null
127: from ben_elig_hrs_wkd_prte_f
128: where hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
129: and eligy_prfl_id = p_eligy_prfl_id
130: and elig_hrs_wkd_prte_id <> nvl(p_elig_hrs_wkd_prte_id,hr_api.g_number)
131: and business_group_id + 0 = p_business_group_id

Line 294: from ben_elig_hrs_wkd_prte_f

290: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
291: l_dummy char(1);
292: cursor c1 is
293: select null
294: from ben_elig_hrs_wkd_prte_f
295: where elig_hrs_wkd_prte_id <> nvl(p_elig_hrs_wkd_prte_id,-1)
296: and eligy_prfl_id = p_eligy_prfl_id
297: and ordr_num = p_ordr_num
298: and business_group_id = p_business_group_id;

Line 665: ben_elig_hrs_wkd_prte_f b

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