APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_ELIGY_PRFL_F

Line 135: FROM BEN_ELIGY_PRFL_F eligy

131:
132: IF (v_ee_id is not null ) THEN
133: SELECT eligy.name
134: INTO p_ee_name
135: FROM BEN_ELIGY_PRFL_F eligy
136: WHERE
137: eligy.ELIGY_PRFL_ID(+) = v_ee_id
138: AND v_period_end_date >= eligy.effective_start_date(+)
139: AND (eligy.effective_end_date IS NULL OR eligy.effective_end_date >= v_period_end_date) ;

Line 2670: FROM BEN_ELIGY_PRFL_F

2666: WRITE ('valid statement setup...');
2667: stmt_record_rec (l_loop_cnt).statement_rec.valid_flag := 'Y';
2668: IF (stmt_record_rec (l_loop_cnt).statement_rec.ee_id IS NOT NULL ) THEN
2669: SELECT ELIGY_PRFL_ID INTO stmt_record_rec (l_loop_cnt).statement_rec.ee_id
2670: FROM BEN_ELIGY_PRFL_F
2671: WHERE STAT_CD='A'
2672: AND ELIGY_PRFL_ID = stmt_record_rec (l_loop_cnt).statement_rec.ee_id
2673: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2674:

Line 2757: FROM BEN_ELIGY_PRFL_F

2753: hr_utility.set_location('checking the eligibity of the person_id id :'|| p_person_id ||'.Eligibility profile id is
2754: '||stmt_rec.ee_id ,166 );
2755:
2756: SELECT ELIGY_PRFL_ID INTO temp_ee_id
2757: FROM BEN_ELIGY_PRFL_F
2758: WHERE STAT_CD='A'
2759: AND ELIGY_PRFL_ID = stmt_rec.ee_id
2760: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2761:

Line 2901: FROM BEN_ELIGY_PRFL_F

2897: hr_utility.set_location(g_actn,172);
2898: temp_ee_id :=null;
2899: IF (stmt_rec.ee_id IS NOT NULL ) THEN
2900: SELECT ELIGY_PRFL_ID INTO temp_ee_id
2901: FROM BEN_ELIGY_PRFL_F
2902: WHERE STAT_CD='A'
2903: AND ELIGY_PRFL_ID = stmt_rec.ee_id
2904: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2905: END IF;