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.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 109: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;

105: l_configuration_information9 VARCHAR2(10) := 'N' ;
106: l_configuration_information10 VARCHAR2(10) := 'N' ;
107:
108: l_ee_contribution_bal_type_id
109: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
110:
111: l_er_contribution_bal_type_id
112: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
113:

Line 112: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;

108: l_ee_contribution_bal_type_id
109: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
110:
111: l_er_contribution_bal_type_id
112: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
113:
114: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
115: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
116: l_pen_sal_bal_type_id

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

113:
114: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
115: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
116: l_pen_sal_bal_type_id
117: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
118:
119: l_balance_feed_Id
120: pay_balance_feeds_f.balance_feed_id%TYPE;
121:

Line 188: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;

184: l_retr_22 NUMBER;
185: l_prem_replace_string VARCHAR2(5000) := ' ' ;
186: l_std_link_flag VARCHAR2(10) := 'N';
187: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
188: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
189: l_subcat VARCHAR2(30);
190: l_conversion_rule pqp_pension_types_f.threshold_conversion_rule%TYPE;
191: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
192: l_zvw_text VARCHAR2(5000):= ' ' ;

Line 190: l_conversion_rule pqp_pension_types_f.threshold_conversion_rule%TYPE;

186: l_std_link_flag VARCHAR2(10) := 'N';
187: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
188: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
189: l_subcat VARCHAR2(30);
190: l_conversion_rule pqp_pension_types_f.threshold_conversion_rule%TYPE;
191: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
192: l_zvw_text VARCHAR2(5000):= ' ' ;
193:
194:

Line 191: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;

187: l_scheme_prefix VARCHAR2(50) := p_scheme_prefix;
188: l_pension_sub_category pqp_pension_types_f.pension_sub_category%TYPE;
189: l_subcat VARCHAR2(30);
190: l_conversion_rule pqp_pension_types_f.threshold_conversion_rule%TYPE;
191: l_basis_method pqp_pension_types_f.pension_basis_calc_method%TYPE;
192: l_zvw_text VARCHAR2(5000):= ' ' ;
193:
194:
195: --

Line 229: FROM pqp_pension_types_f

225: --
226: CURSOR csr_pty1 (c_pension_type_id NUMBER
227: ,c_effective_date DATE) IS
228: SELECT *
229: FROM pqp_pension_types_f
230: WHERE pension_type_id = c_pension_type_id
231: AND business_group_id = p_business_group_id
232: AND c_effective_date BETWEEN effective_start_date
233: AND effective_end_date;

Line 235: r_pty_rec pqp_pension_types_f%ROWTYPE;

231: AND business_group_id = p_business_group_id
232: AND c_effective_date BETWEEN effective_start_date
233: AND effective_end_date;
234:
235: r_pty_rec pqp_pension_types_f%ROWTYPE;
236:
237: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
238: SELECT formula_text
239: FROM pay_shadow_formulas