105: AND HR.LOOKUP_TYPE = 'ASG_SET';
106:
107: CURSOR C_INQUIRY_NAME IS
108: SELECT REPS.QP_REPORT_NAME
109: FROM FF_QP_REPORTS REPS,
110: FF_FORMULA_TYPES TYPES
111: WHERE REPS.FORMULA_TYPE_ID = TYPES.FORMULA_TYPE_ID
112: AND REPS.QP_REPORT_ID = P_VALUE;
113:
354: --
355: CURSOR C_INQUIRY_NAME IS
356: SELECT REPS.QP_REPORT_NAME
357: , REPS.LEGISLATION_CODE
358: FROM FF_QP_REPORTS REPS
359: , FF_FORMULA_TYPES TYPES
360: WHERE REPS.FORMULA_TYPE_ID = TYPES.FORMULA_TYPE_ID
361: AND REPS.QP_REPORT_ID = P_VALUE;
362: --
436: AND PUT.LEGISLATION_CODE = P_LEG_CODE));
437: --
438: CURSOR C_INQUIRY_NAME IS
439: SELECT REPS.QP_REPORT_ID
440: FROM FF_QP_REPORTS REPS
441: , FF_FORMULA_TYPES TYPES
442: WHERE REPS.FORMULA_TYPE_ID = TYPES.FORMULA_TYPE_ID
443: AND REPS.QP_REPORT_NAME = P_VALUE
444: AND (P_LEG_CODE IS NULL