APPS.HRI_BPL_ABV dependencies on FF_COMPILED_INFO_F

Line 456: FROM ff_compiled_info_f fci

452: PROCEDURE check_ff_name_compiled( p_formula_name IN VARCHAR2) IS
453:
454: CURSOR compiled_csr IS
455: SELECT fci.formula_id
456: FROM ff_compiled_info_f fci
457: ,ff_formulas_f fff
458: WHERE fci.formula_id = fff.formula_id
459: AND fff.formula_type_id = g_formula_type_id
460: AND fff.formula_name = p_formula_name

Line 464: l_formula_id ff_compiled_info_f.formula_id%TYPE := NULL;

460: AND fff.formula_name = p_formula_name
461: AND trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
462: AND trunc(sysdate) BETWEEN fci.effective_start_date AND fci.effective_end_date;
463:
464: l_formula_id ff_compiled_info_f.formula_id%TYPE := NULL;
465:
466: BEGIN
467:
468: OPEN compiled_csr;

Line 488: FROM ff_compiled_info_f

484: IS
485:
486: CURSOR fast_formula_compiled_csr IS
487: SELECT formula_id
488: FROM ff_compiled_info_f
489: WHERE formula_id = p_formula_id;
490:
491: l_formula_id ff_compiled_info_f.formula_id%TYPE := NULL;
492:

Line 491: l_formula_id ff_compiled_info_f.formula_id%TYPE := NULL;

487: SELECT formula_id
488: FROM ff_compiled_info_f
489: WHERE formula_id = p_formula_id;
490:
491: l_formula_id ff_compiled_info_f.formula_id%TYPE := NULL;
492:
493: BEGIN
494:
495: IF p_formula_id IS NULL THEN