APPS.HR_WPM_MASS_APR_PUSH dependencies on BEN_ELIG_OBJ_F

Line 2426: FROM ben_elig_obj_f elig

2422: p_appr_period_id per_appraisal_periods.appraisal_period_id%TYPE
2423: )
2424: IS
2425: SELECT elig.elig_obj_id
2426: FROM ben_elig_obj_f elig
2427: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'
2428: AND elig.column_name = 'APPRAISAL_PERIOD_ID'
2429: AND elig.COLUMN_VALUE = p_appr_period_id
2430: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date

Line 2438: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

2434: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
2435: l_obj_date DATE := TRUNC (SYSDATE);
2436: l_scorecard_status_code VARCHAR2 (30);
2437: l_check_elig VARCHAR2 (1);
2438: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
2439:
2440: --
2441: -- cursor to select pending transactions for a given scorecard
2442: --