APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_BALANCE_TYPES

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

51: l_ele_new_name t_ele_name;
52: l_main_ele_name t_ele_name;
53: l_retro_ele_name t_ele_name;
54:
55: TYPE t_bal_name IS TABLE OF pay_balance_types.balance_name%TYPE
56: INDEX BY BINARY_INTEGER;
57: l_bal_name t_bal_name;
58: l_bal_new_name t_bal_name;
59:

Line 114: l_ee_retro_bal_id pay_balance_types.balance_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
117: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
118:

Line 115: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;

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
117: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
118:
119: l_balance_feed_Id

Line 131: l_balance_name pay_balance_types.balance_name%TYPE;

127: l_formula_text1 VARCHAR2(32767);
128: l_tax_si_text VARCHAR2(32767);
129: l_abs_text VARCHAR2(32767);
130: l_dbi_user_name ff_database_items.user_name%TYPE;
131: l_balance_name pay_balance_types.balance_name%TYPE;
132: l_balance_dbi_name ff_database_items.user_name%TYPE;
133: l_template_id pay_shadow_element_types.template_id%TYPE;
134: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
135: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 285: FROM pay_balance_types_tl

281:
282: CURSOR c_get_retro_bal_id(c_subcat IN VARCHAR2
283: ,c_ee_er IN VARCHAR2) IS
284: SELECT balance_type_id
285: FROM pay_balance_types_tl
286: WHERE balance_name = 'Retro '||c_subcat||' '
287: ||c_ee_er||' Contribution'
288: AND LANGUAGE = 'US';
289: