APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_ANALYSIS_CRITERIA

Line 986: FROM per_analysis_criteria

982: CURSOR csr_kff_seg (c_anal_criteria_id IN NUMBER
983: ,c_flex_num IN NUMBER
984: ,c_effective_date IN DATE) IS
985: SELECT *
986: FROM per_analysis_criteria
987: WHERE analysis_criteria_id = c_anal_criteria_id
988: AND id_flex_num = c_flex_num
989: AND c_effective_date BETWEEN NVL(start_date_active,c_effective_date)
990: AND NVL(end_date_active,c_effective_date);

Line 992: l_analysis_criteria_rec per_analysis_criteria%ROWTYPE;

988: AND id_flex_num = c_flex_num
989: AND c_effective_date BETWEEN NVL(start_date_active,c_effective_date)
990: AND NVL(end_date_active,c_effective_date);
991:
992: l_analysis_criteria_rec per_analysis_criteria%ROWTYPE;
993:
994: l_asg_rec csr_asg%ROWTYPE;
995: Invaild_kff_flex EXCEPTION;
996: l_return_value VARCHAR2(150);