DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on FF_QP_REPORTS

Line 109: FROM FF_QP_REPORTS REPS,

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:

Line 358: FROM FF_QP_REPORTS REPS

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: --

Line 440: FROM FF_QP_REPORTS REPS

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