DBA Data[Home] [Help]

APPS.HRI_BPL_SETUP_DIAGNOSTIC dependencies on FF_FORMULAS_F

Line 443: FROM ff_formulas_f ff

439:
440: -- Cursor to check the existence of the seeded fast formulas as on sysdate
441: CURSOR c_seeded_ff_nm(p_obj_nm VARCHAR2) IS
442: SELECT 'FFP'||formula_id||'_'||TO_CHAR(effective_start_date,'DDMMYYYY') ff_name
443: FROM ff_formulas_f ff
444: WHERE ff.formula_name = p_obj_nm
445: AND ff.business_group_id IS NULL
446: AND trunc(SYSDATE) BETWEEN ff.effective_start_date AND ff.effective_end_date
447: ORDER BY ff_name;