APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIGY_CRIT_VALUES_F

Line 3817: ------------- START OF BEN_ELIGY_CRIT_VALUES_F ----------------

3813: -- END OF BEN_ELIG_ANTHR_PL_PRTE_F ----------------------
3814: ---------------------------------------------------------------
3815:
3816: ---------------------------------------------------------------
3817: ------------- START OF BEN_ELIGY_CRIT_VALUES_F ----------------
3818: ---------------------------------------------------------------
3819: CURSOR c_ecv_from_parent (cv_eligy_prfl_id NUMBER)
3820: IS
3821: SELECT eligy_crit_values_id

Line 3822: FROM ben_eligy_crit_values_f

3818: ---------------------------------------------------------------
3819: CURSOR c_ecv_from_parent (cv_eligy_prfl_id NUMBER)
3820: IS
3821: SELECT eligy_crit_values_id
3822: FROM ben_eligy_crit_values_f
3823: WHERE eligy_prfl_id = cv_eligy_prfl_id;
3824: --
3825: CURSOR c_ecv (
3826: cv_eligy_crit_values_id NUMBER,

Line 3832: FROM ben_eligy_crit_values_f ecv

3828: cv_table_alias VARCHAR2
3829: )
3830: IS
3831: SELECT ecv.*
3832: FROM ben_eligy_crit_values_f ecv
3833: WHERE ecv.eligy_crit_values_id = cv_eligy_crit_values_id
3834: AND NOT EXISTS (
3835: SELECT NULL
3836: FROM ben_copy_entity_results cpe

Line 3861: -------------- END OF BEN_ELIGY_CRIT_VALUES_F -----------------

3857: l_start_pos_name varchar2(240);
3858: l_eligy_criteria_id NUMBER (15);
3859: --
3860: ---------------------------------------------------------------
3861: -------------- END OF BEN_ELIGY_CRIT_VALUES_F -----------------
3862: ---------------------------------------------------------------
3863: /*
3864: Bug : 4347039. Moved the code to copy BEN_ELIGY_CRITERIA data
3865: into the procedure create_eligy_criteria_result

Line 11857: -------------- START OF BEN_ELIGY_CRIT_VALUES_F ---------------

11853: --
11854: -- Bug 4169120 : Rate By Criteria
11855: --
11856: ---------------------------------------------------------------
11857: -------------- START OF BEN_ELIGY_CRIT_VALUES_F ---------------
11858: ---------------------------------------------------------------
11859: --
11860: for l_parent_rec in c_ecv_from_parent(l_ELIGY_PRFL_ID)
11861: loop

Line 12191: --------------- END OF BEN_ELIGY_CRIT_VALUES_F ----------------

12187: --
12188: end loop;
12189: --
12190: ---------------------------------------------------------------
12191: --------------- END OF BEN_ELIGY_CRIT_VALUES_F ----------------
12192: ---------------------------------------------------------------
12193:
12194: end if;
12195: ---------------------------------------------------------------