DBA Data[Home] [Help]

APPS.BEN_DPNT_EGD_BUS dependencies on BEN_DPNT_ELIGY_CRIT_VALUES_F

Line 741: -- ben_dpnt_eligy_crit_values_f table when the user deletes the record in the ben_

737: -- -------------------------------------------------------------------------
738: --
739: -- Description
740: -- This procedure is used to check that eligy criteria do not exist in the
741: -- ben_dpnt_eligy_crit_values_f table when the user deletes the record in the ben_
742: -- eligy_criteria table.
743: --
744: -- Pre Conditions
745: -- None.

Line 766: from ben_dpnt_eligy_crit_values_f ecv

762: v_dummy varchar2(1);
763: --
764: cursor chk_eligy_criteria is
765: select null
766: from ben_dpnt_eligy_crit_values_f ecv
767: where ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;
768:
769: begin
770: --

Line 1203: from ben_dpnt_eligy_crit_values_f ecv

1199: l_api_updating boolean;
1200: --
1201: cursor chk_eligy_criteria is
1202: select null
1203: from ben_dpnt_eligy_crit_values_f ecv
1204: where ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;
1205: --
1206: Begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);