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 2701: FROM BEN_ELIGY_PRFL_F

2697: WRITE ('valid statement setup...');
2698: stmt_record_rec (l_loop_cnt).statement_rec.valid_flag := 'Y';
2699: IF (stmt_record_rec (l_loop_cnt).statement_rec.ee_id IS NOT NULL ) THEN
2700: SELECT ELIGY_PRFL_ID INTO stmt_record_rec (l_loop_cnt).statement_rec.ee_id
2701: FROM BEN_ELIGY_PRFL_F
2702: WHERE STAT_CD='A'
2703: AND ELIGY_PRFL_ID = stmt_record_rec (l_loop_cnt).statement_rec.ee_id
2704: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2705:

Line 2788: FROM BEN_ELIGY_PRFL_F

2784: hr_utility.set_location('checking the eligibity of the person_id id :'|| p_person_id ||'.Eligibility profile id is
2785: '||stmt_rec.ee_id ,166 );
2786:
2787: SELECT ELIGY_PRFL_ID INTO temp_ee_id
2788: FROM BEN_ELIGY_PRFL_F
2789: WHERE STAT_CD='A'
2790: AND ELIGY_PRFL_ID = stmt_rec.ee_id
2791: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2792:

Line 2932: FROM BEN_ELIGY_PRFL_F

2928: hr_utility.set_location(g_actn,172);
2929: temp_ee_id :=null;
2930: IF (stmt_rec.ee_id IS NOT NULL ) THEN
2931: SELECT ELIGY_PRFL_ID INTO temp_ee_id
2932: FROM BEN_ELIGY_PRFL_F
2933: WHERE STAT_CD='A'
2934: AND ELIGY_PRFL_ID = stmt_rec.ee_id
2935: AND l_period_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2936: END IF;