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 1511: p_parent_table_name => 'BEN_ELIGY_PRFL_F', /* Bug 4057566 */

1507: -- A referential integrity check was violated therefore
1508: -- we must error
1509: --
1510: ben_utility.child_exists_error(p_table_name => l_table_name,
1511: p_parent_table_name => 'BEN_ELIGY_PRFL_F', /* Bug 4057566 */
1512: p_parent_entity_name => p_name); /* Bug 4057566 */
1513: --
1514: When Others Then
1515: --

Line 1645: FROM ben_eligy_prfl_f elp

1641: --
1642: CURSOR c_elp_name
1643: IS
1644: SELECT elp.NAME
1645: FROM ben_eligy_prfl_f elp
1646: WHERE elp.eligy_prfl_id = p_rec.eligy_prfl_id
1647: AND p_effective_date BETWEEN elp.effective_start_date
1648: AND elp.effective_end_date;
1649: --

Line 1650: l_elp_name ben_eligy_prfl_f.name%type;

1646: WHERE elp.eligy_prfl_id = p_rec.eligy_prfl_id
1647: AND p_effective_date BETWEEN elp.effective_start_date
1648: AND elp.effective_end_date;
1649: --
1650: l_elp_name ben_eligy_prfl_f.name%type;
1651: --
1652: Begin
1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --

Line 1768: p_parent_table_name => 'BEN_ELIGY_PRFL_F',

1764: --
1765: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1766: -- hr_utility.raise_error;
1767: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1768: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1769: p_parent_entity_name => l_elp_name);
1770: --
1771: -- Bug 4057566
1772: --

Line 1793: ben_eligy_prfl_f b

1789: --
1790: cursor csr_leg_code is
1791: select a.legislation_code
1792: from per_business_groups a,
1793: ben_eligy_prfl_f b
1794: where b.eligy_prfl_id = p_eligy_prfl_id
1795: and a.business_group_id = b.business_group_id;
1796: --
1797: -- Declare local variables