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_NL_PGGM_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 185: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;

181: l_configuration_information8 VARCHAR2(10) := 'N' ;
182: l_configuration_information9 VARCHAR2(10) := 'N' ;
183: l_configuration_information10 VARCHAR2(10) := 'N' ;
184: l_ee_contribution_bal_type_id
185: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
186: l_er_contribution_bal_type_id
187: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
188: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
189: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;

Line 187: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;

183: l_configuration_information10 VARCHAR2(10) := 'N' ;
184: l_ee_contribution_bal_type_id
185: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
186: l_er_contribution_bal_type_id
187: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
188: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
189: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
190: l_pen_sal_bal_type_id
191: pqp_pension_types_f.pension_salary_balance%TYPE := -1;

Line 191: pqp_pension_types_f.pension_salary_balance%TYPE := -1;

187: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
188: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
189: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
190: l_pen_sal_bal_type_id
191: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
192: l_balance_feed_Id
193: pay_balance_feeds_f.balance_feed_id%TYPE;
194: l_row_id ROWID;
195: l_request_id NUMBER;

Line 246: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;

242: l_retr_22 NUMBER;
243: l_prem_replace_string VARCHAR2(5000) := ' ' ;
244: l_std_link_flag VARCHAR2(10) := 'N';
245: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
246: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
247: l_subcat VARCHAR2(30);
248: l_conversion_rule
249: pqp_pension_types_f.threshold_conversion_rule%TYPE;
250: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 249: pqp_pension_types_f.threshold_conversion_rule%TYPE;

245: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
246: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
247: l_subcat VARCHAR2(30);
248: l_conversion_rule
249: pqp_pension_types_f.threshold_conversion_rule%TYPE;
250: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
251:
252:
253:

Line 250: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

246: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
247: l_subcat VARCHAR2(30);
248: l_conversion_rule
249: pqp_pension_types_f.threshold_conversion_rule%TYPE;
250: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
251:
252:
253:
254:

Line 289: FROM pqp_pension_types_f

285: --
286: CURSOR csr_pty1 (c_pension_type_id NUMBER
287: ,c_effective_date DATE) IS
288: SELECT *
289: FROM pqp_pension_types_f
290: WHERE pension_type_id = c_pension_type_id
291: AND business_group_id = p_business_group_id
292: AND c_effective_date BETWEEN effective_start_date
293: AND effective_end_date;

Line 295: r_pty_rec pqp_pension_types_f%ROWTYPE;

291: AND business_group_id = p_business_group_id
292: AND c_effective_date BETWEEN effective_start_date
293: AND effective_end_date;
294:
295: r_pty_rec pqp_pension_types_f%ROWTYPE;
296:
297: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
298: SELECT formula_text
299: FROM pay_shadow_formulas