DBA Data[Home] [Help]

APPS.BEN_ECT_BUS dependencies on BEN_ELIG_DSBLTY_CTG_PRTE_F

Line 134: from ben_elig_dsblty_ctg_prte_f

130: --
131: --
132: cursor c3 is
133: select null
134: from ben_elig_dsblty_ctg_prte_f
135: where category = p_category
136: and eligy_prfl_id = p_eligy_prfl_id
137: and elig_dsblty_ctg_prte_id <> nvl(p_elig_dsblty_ctg_prte_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id

Line 758: ben_elig_dsblty_ctg_prte_f b

754: --
755: cursor csr_leg_code is
756: select a.legislation_code
757: from per_business_groups a,
758: ben_elig_dsblty_ctg_prte_f b
759: where b.elig_dsblty_ctg_prte_id = p_elig_dsblty_ctg_prte_id
760: and a.business_group_id = b.business_group_id;
761: --
762: -- Declare local variables