APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 134: TYPE t_bal_name IS TABLE OF pay_balance_types.balance_name%TYPE

130: l_ele_new_name t_ele_name;
131: l_main_ele_name t_ele_name;
132: l_retro_ele_name t_ele_name;
133:
134: TYPE t_bal_name IS TABLE OF pay_balance_types.balance_name%TYPE
135: INDEX BY BINARY_INTEGER;
136: l_bal_name t_bal_name;
137: l_bal_new_name t_bal_name;
138:

Line 188: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;

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;
192: l_balance_feed_Id

Line 189: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;

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;
192: l_balance_feed_Id
193: pay_balance_feeds_f.balance_feed_id%TYPE;

Line 202: l_balance_name pay_balance_types.balance_name%TYPE;

198: l_formula_text1 VARCHAR2(32767);
199: l_tax_si_text VARCHAR2(32767);
200: l_abs_text VARCHAR2(32767);
201: l_dbi_user_name ff_database_items.user_name%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 343: FROM pay_balance_types

339: -- Cursor added to find the balance name for the
340: -- Pension Salary Balance for
341: CURSOR csr_get_pen_sal_bal_name (c_bal_type_id NUMBER) IS
342: SELECT balance_name
343: FROM pay_balance_types
344: WHERE balance_type_id = c_bal_type_id
345: AND (business_group_id = p_business_group_id
346: OR business_group_id IS NULL
347: OR legislation_code = 'NL');

Line 360: FROM pay_balance_types_tl

356:
357: CURSOR c_get_retro_bal_id(c_subcat IN VARCHAR2
358: ,c_ee_er IN VARCHAR2) IS
359: SELECT balance_type_id
360: FROM pay_balance_types_tl
361: WHERE balance_name = 'Retro '||c_subcat||' '
362: ||c_ee_er||' Contribution'
363: AND LANGUAGE = 'US';
364: