APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on FF_FORMULAS_F

Line 111: l_new_skip_rule_id ff_formulas_f.formula_id%TYPE;

107: l_effective_end_date date;
108: l_count number;
109: l_accrual_class_id number;
110: l_accrual_classification_name varchar2(30) := 'Accrual Information';
111: l_new_skip_rule_id ff_formulas_f.formula_id%TYPE;
112:
113:
114: type inp_val_table IS TABLE of pay_input_values.input_value_id%type
115: index by binary_integer;

Line 158: from ff_formulas_f f1, ff_formula_types ft

154: and CLASSIFICATION_NAME = 'Accrual Information';
155:
156: cursor csr_skip_rule is
157: select f1.formula_id
158: from ff_formulas_f f1, ff_formula_types ft
159: where f1.formula_name = 'FR_PROCESS_IN_LAST_PRORATION_PERIOD_PROCESSED'
160: and f1.formula_type_id = ft.formula_type_id
161: and ft.formula_type_name = 'Element Skip'
162: and f1.effective_start_date = (select max(f0.effective_start_date)

Line 163: from ff_formulas_f f0

159: where f1.formula_name = 'FR_PROCESS_IN_LAST_PRORATION_PERIOD_PROCESSED'
160: and f1.formula_type_id = ft.formula_type_id
161: and ft.formula_type_name = 'Element Skip'
162: and f1.effective_start_date = (select max(f0.effective_start_date)
163: from ff_formulas_f f0
164: where f0.legislation_code = 'FR'
165: and f0.formula_id = f1.formula_id
166: and f0.formula_type_id = f1.formula_type_id
167: and f0.business_Group_id is null);

Line 203: FROM ff_formulas_f

199: l_input_value t_input_value;
200:
201: cursor csr_formula_exists IS
202: SELECT formula_id
203: FROM ff_formulas_f
204: WHERE formula_name = 'FR_HOLIDAY_TERMINATION_PAYMENT'
205: AND legislation_code = 'FR';
206:
207: cursor Earnings_class_id is