DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on FF_FORMULAS_F

Line 25: from ff_formulas_f fra,

21: fra.formula_id,
22: fra.formula_name,
23: fty.formula_type_id,
24: fty.formula_type_name
25: from ff_formulas_f fra,
26: ff_formula_types fty,
27: pay_status_processing_rules_f spr
28: where fty.formula_type_id = fra.formula_type_id
29: and fra.formula_id = spr.formula_id

Line 207: FROM ff_formulas_f

203:
204: CURSOR c_formula_id (c_name IN VARCHAR2)
205: IS
206: SELECT formula_id
207: FROM ff_formulas_f
208: WHERE formula_name=upper(c_name)
209: AND business_group_id=p_business_group_id
210: AND trunc(p_scheme_start_date) BETWEEN
211: effective_start_date AND effective_end_date;