eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on FF_FORMULAS_F

Line 174: l_skip_formula ff_formulas_f.formula_name%TYPE;

170: l_exc_ssal_rule_id VARCHAR2 (1);
171: l_exc_vol_con_rule_id VARCHAR2 (1);
172: l_exc_fsavc_eer_rule_id VARCHAR2 (1);
173: l_cont_iv_name pay_input_values_f.NAME%TYPE;
174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;

Line 179: l_iterative_formula ff_formulas_f.formula_name%TYPE;

175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;
181: l_pensionable_sal_bal_id NUMBER;
182: l_pensionable_sal_bal_name pay_balance_types.balance_name%TYPE;
183: l_arrearage_allowed VARCHAR2 (1)

Line 193: l_ees_cont_formula ff_formulas_f.formula_name%TYPE

189: ,'N'
190: );
191: l_format_base_name pay_element_templates.base_name%TYPE
192: := UPPER (TRANSLATE (TRIM (p_ele_base_name), ' ', '_'));
193: l_ees_cont_formula ff_formulas_f.formula_name%TYPE
194: := l_format_base_name
195: || '_EES_'
196: || p_pension_category
197: || '_CONTRIBUTION_FORMULA';

Line 198: l_ees_cont_formula_id ff_formulas_f.formula_id%TYPE;

194: := l_format_base_name
195: || '_EES_'
196: || p_pension_category
197: || '_CONTRIBUTION_FORMULA';
198: l_ees_cont_formula_id ff_formulas_f.formula_id%TYPE;
199: l_ers_cont_formula ff_formulas_f.formula_name%TYPE
200: := l_format_base_name
201: || '_ERS_PENSION_CONTRIBUTION_FORMULA';
202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;

Line 199: l_ers_cont_formula ff_formulas_f.formula_name%TYPE

195: || '_EES_'
196: || p_pension_category
197: || '_CONTRIBUTION_FORMULA';
198: l_ees_cont_formula_id ff_formulas_f.formula_id%TYPE;
199: l_ers_cont_formula ff_formulas_f.formula_name%TYPE
200: := l_format_base_name
201: || '_ERS_PENSION_CONTRIBUTION_FORMULA';
202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;
203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE

Line 202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;

198: l_ees_cont_formula_id ff_formulas_f.formula_id%TYPE;
199: l_ers_cont_formula ff_formulas_f.formula_name%TYPE
200: := l_format_base_name
201: || '_ERS_PENSION_CONTRIBUTION_FORMULA';
202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;
203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE
204: := l_format_base_name
205: || '_ADDITIONAL_CONTRIBUTION_FORMULA';
206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;

Line 203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE

199: l_ers_cont_formula ff_formulas_f.formula_name%TYPE
200: := l_format_base_name
201: || '_ERS_PENSION_CONTRIBUTION_FORMULA';
202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;
203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE
204: := l_format_base_name
205: || '_ADDITIONAL_CONTRIBUTION_FORMULA';
206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;
207: l_ayr_cont_formula ff_formulas_f.formula_name%TYPE

Line 206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;

202: l_ers_cont_formula_id ff_formulas_f.formula_id%TYPE;
203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE
204: := l_format_base_name
205: || '_ADDITIONAL_CONTRIBUTION_FORMULA';
206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;
207: l_ayr_cont_formula ff_formulas_f.formula_name%TYPE
208: := l_format_base_name
209: || '_ADDED_YEARS_CONTRIBUTION_FORMULA';
210: l_ayr_cont_formula_id ff_formulas_f.formula_id%TYPE;

Line 207: l_ayr_cont_formula ff_formulas_f.formula_name%TYPE

203: l_adl_cont_formula ff_formulas_f.formula_name%TYPE
204: := l_format_base_name
205: || '_ADDITIONAL_CONTRIBUTION_FORMULA';
206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;
207: l_ayr_cont_formula ff_formulas_f.formula_name%TYPE
208: := l_format_base_name
209: || '_ADDED_YEARS_CONTRIBUTION_FORMULA';
210: l_ayr_cont_formula_id ff_formulas_f.formula_id%TYPE;
211:

Line 210: l_ayr_cont_formula_id ff_formulas_f.formula_id%TYPE;

206: l_adl_cont_formula_id ff_formulas_f.formula_id%TYPE;
207: l_ayr_cont_formula ff_formulas_f.formula_name%TYPE
208: := l_format_base_name
209: || '_ADDED_YEARS_CONTRIBUTION_FORMULA';
210: l_ayr_cont_formula_id ff_formulas_f.formula_id%TYPE;
211:
212: l_fwd_cont_formula ff_formulas_f.formula_name%TYPE
213: := l_format_base_name
214: || '_FAMILY_WIDOWER_CONTRIBUTION_FORMULA';

Line 212: l_fwd_cont_formula ff_formulas_f.formula_name%TYPE

208: := l_format_base_name
209: || '_ADDED_YEARS_CONTRIBUTION_FORMULA';
210: l_ayr_cont_formula_id ff_formulas_f.formula_id%TYPE;
211:
212: l_fwd_cont_formula ff_formulas_f.formula_name%TYPE
213: := l_format_base_name
214: || '_FAMILY_WIDOWER_CONTRIBUTION_FORMULA';
215: l_fwd_cont_formula_id ff_formulas_f.formula_id%TYPE;
216:

Line 215: l_fwd_cont_formula_id ff_formulas_f.formula_id%TYPE;

211:
212: l_fwd_cont_formula ff_formulas_f.formula_name%TYPE
213: := l_format_base_name
214: || '_FAMILY_WIDOWER_CONTRIBUTION_FORMULA';
215: l_fwd_cont_formula_id ff_formulas_f.formula_id%TYPE;
216:
217: l_bb_fwc_cont_formula ff_formulas_f.formula_name%TYPE
218: := l_format_base_name
219: || '_EES_BUY_BACK_FWC_CONTRIBUTION_FORMULA';

Line 217: l_bb_fwc_cont_formula ff_formulas_f.formula_name%TYPE

213: := l_format_base_name
214: || '_FAMILY_WIDOWER_CONTRIBUTION_FORMULA';
215: l_fwd_cont_formula_id ff_formulas_f.formula_id%TYPE;
216:
217: l_bb_fwc_cont_formula ff_formulas_f.formula_name%TYPE
218: := l_format_base_name
219: || '_EES_BUY_BACK_FWC_CONTRIBUTION_FORMULA';
220: l_bb_fwc_cont_formula_id ff_formulas_f.formula_id%TYPE;
221:

Line 220: l_bb_fwc_cont_formula_id ff_formulas_f.formula_id%TYPE;

216:
217: l_bb_fwc_cont_formula ff_formulas_f.formula_name%TYPE
218: := l_format_base_name
219: || '_EES_BUY_BACK_FWC_CONTRIBUTION_FORMULA';
220: l_bb_fwc_cont_formula_id ff_formulas_f.formula_id%TYPE;
221:
222:
223: l_search_string VARCHAR2 (2000);
224: l_replace_string VARCHAR2 (2000);

Line 486: FROM ff_formulas_f fra

482: CURSOR csr_get_ff_id (c_element_type_id NUMBER)
483: IS
484: SELECT fra.formula_id, fra.formula_name, fty.formula_type_id
485: ,fty.formula_type_name
486: FROM ff_formulas_f fra
487: ,ff_formula_types fty
488: ,pay_status_processing_rules_f spr
489: WHERE fty.formula_type_id = fra.formula_type_id
490: AND fra.formula_id = spr.formula_id