DBA Data[Home] [Help]

APPS.OKL_RPP_PVT dependencies on FND_LOOKUPS

Line 315: fnd_lookups b

311: p_report_id OKL_REPORT_PARAMETERS.REPORT_ID%TYPE
312: ,p_param_type_code OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE) IS
313: select 1
314: from okl_report_parameters a,
315: fnd_lookups b
316: where b.lookup_type='OKL_PARAMETER_TYPES'
317: and b.lookup_code = a.parameter_type_code
318: and a.parameter_type_code = p_param_type_code
319: and a.report_id = p_report_id;

Line 324: FROM FND_LOOKUPS

320:
321: -- cursor to validate book classification code
322: CURSOR c_is_valid_bcc(p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE) IS
323: SELECT 1
324: FROM FND_LOOKUPS
325: WHERE LOOKUP_TYPE = 'OKL_BOOK_CLASS'
326: AND LOOKUP_CODE = p_bcc_value;
327:
328: BEGIN