APPS.BEN_ELP_BUS dependencies on BEN_ELIGY_PRFL_F

Line 122: from ben_eligy_prfl_f

118: --
119: --
120: cursor csr_name is
121: select null
122: from ben_eligy_prfl_f
123: where name = p_name
124: and eligy_prfl_id <> nvl(p_eligy_prfl_id, hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date

Line 381: FROM ben_eligy_prfl_f

377: --Start Enh: 13478736 - Learner Access Eligibility Enhancement
378: Cursor c_lrnr_group
379: is
380: SELECT 'Y'
381: FROM ben_eligy_prfl_f
382: WHERE eligy_prfl_id = p_eligy_prfl_id
383: AND p_validation_start_date <= effective_end_date
384: AND p_validation_end_date >= effective_start_date
385: AND bnft_cagr_prtn_cd = 'LRNR';

Line 1536: p_parent_table_name => 'BEN_ELIGY_PRFL_F', /* Bug 4057566 */

1532: -- A referential integrity check was violated therefore
1533: -- we must error
1534: --
1535: ben_utility.child_exists_error(p_table_name => l_table_name,
1536: p_parent_table_name => 'BEN_ELIGY_PRFL_F', /* Bug 4057566 */
1537: p_parent_entity_name => p_name); /* Bug 4057566 */
1538: --
1539: When Others Then
1540: --

Line 1670: FROM ben_eligy_prfl_f elp

1666: --
1667: CURSOR c_elp_name
1668: IS
1669: SELECT elp.NAME
1670: FROM ben_eligy_prfl_f elp
1671: WHERE elp.eligy_prfl_id = p_rec.eligy_prfl_id
1672: AND p_effective_date BETWEEN elp.effective_start_date
1673: AND elp.effective_end_date;
1674: --

Line 1675: l_elp_name ben_eligy_prfl_f.name%type;

1671: WHERE elp.eligy_prfl_id = p_rec.eligy_prfl_id
1672: AND p_effective_date BETWEEN elp.effective_start_date
1673: AND elp.effective_end_date;
1674: --
1675: l_elp_name ben_eligy_prfl_f.name%type;
1676: --
1677: Begin
1678: hr_utility.set_location('Entering:'||l_proc, 5);
1679: --

Line 1793: p_parent_table_name => 'BEN_ELIGY_PRFL_F',

1789: --
1790: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1791: -- hr_utility.raise_error;
1792: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1793: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1794: p_parent_entity_name => l_elp_name);
1795: --
1796: -- Bug 4057566
1797: --

Line 1818: ben_eligy_prfl_f b

1814: --
1815: cursor csr_leg_code is
1816: select a.legislation_code
1817: from per_business_groups a,
1818: ben_eligy_prfl_f b
1819: where b.eligy_prfl_id = p_eligy_prfl_id
1820: and a.business_group_id = b.business_group_id;
1821: --
1822: -- Declare local variables