DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on FF_FORMULA_TYPES

Line 110: FF_FORMULA_TYPES TYPES

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:
114: CURSOR C_ORG_CLASS IS

Line 359: , FF_FORMULA_TYPES TYPES

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: --
363: CURSOR C_SPECIAL_INFO IS

Line 441: , FF_FORMULA_TYPES TYPES

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
445: OR (P_LEG_CODE IS NOT NULL