APPS.PAY_NL_GENERAL dependencies on FF_FORMULAS_F

Line 992: FROM ff_formulas_f ff

988:
989: --
990: CURSOR c_compiled_formula_exist IS
991: SELECT 'Y'
992: FROM ff_formulas_f ff
993: ,ff_compiled_info_f ffci
994: WHERE ff.formula_id = ffci.formula_id
995: AND ff.effective_start_date = ffci.effective_start_date
996: AND ff.effective_end_date = ffci.effective_end_date

Line 1002: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE

998: AND ff.business_group_id = p_business_group_id
999: AND p_effective_date BETWEEN ff.effective_start_date
1000: AND ff.effective_end_date;
1001: --
1002: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
1003: ,p_effective_date DATE) IS
1004: SELECT ff.formula_id
1005: FROM ff_formulas_f ff
1006: WHERE ff.formula_name = p_formula_name

Line 1005: FROM ff_formulas_f ff

1001: --
1002: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
1003: ,p_effective_date DATE) IS
1004: SELECT ff.formula_id
1005: FROM ff_formulas_f ff
1006: WHERE ff.formula_name = p_formula_name
1007: AND ff.business_group_id = p_business_group_id
1008: AND p_effective_date BETWEEN ff.effective_start_date
1009: AND ff.effective_end_date;