APPS.PQP_PENSION_EXTRACTS dependencies on PER_ANALYSIS_CRITERIA

Line 2637: FROM per_analysis_criteria

2633: CURSOR csr_kff_seg (c_anal_criteria_id IN NUMBER
2634: ,c_flex_num IN NUMBER
2635: ,c_effective_date IN DATE) IS
2636: SELECT *
2637: FROM per_analysis_criteria
2638: WHERE analysis_criteria_id = c_anal_criteria_id
2639: AND id_flex_num = c_flex_num
2640: AND c_effective_date BETWEEN NVL(start_date_active,c_effective_date)
2641: AND NVL(end_date_active,c_effective_date);

Line 2643: l_analysis_criteria_rec per_analysis_criteria%ROWTYPE;

2639: AND id_flex_num = c_flex_num
2640: AND c_effective_date BETWEEN NVL(start_date_active,c_effective_date)
2641: AND NVL(end_date_active,c_effective_date);
2642:
2643: l_analysis_criteria_rec per_analysis_criteria%ROWTYPE;
2644:
2645: l_asg_rec csr_asg%ROWTYPE;
2646: Invaild_kff_flex EXCEPTION;
2647: l_return_value VARCHAR2(150);