DBA Data[Home] [Help]

APPS.HRI_BPL_PERSON_TYPE dependencies on FF_FORMULAS_F

Line 388: FROM ff_formulas_f

384: -- Cursor to fetch peformance rating fast formula
385: --
386: CURSOR c_perf_formula IS
387: SELECT formula_id
388: FROM ff_formulas_f
389: WHERE business_group_id = p_business_group_id
390: AND p_date BETWEEN effective_start_date
391: AND effective_end_date
392: AND formula_name = p_ff_name;

Line 515: ff_formulas_f fff

511: -- If that doesn't exist then finds a global formula (Setup BG)
512: CURSOR worker_cat_ff_csr IS
513: SELECT fff.formula_id
514: FROM
515: ff_formulas_f fff
516: ,ff_formula_types fft
517: WHERE fft.formula_type_name = 'QuickPaint'
518: AND trunc(sysdate) between fff.effective_start_date AND fff.effective_end_date
519: AND fff.formula_type_id = fft.formula_type_id