APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_BALANCE_TYPES

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

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

Line 100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;

96: l_ee_contribution_bal_type_id
97: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
98: l_er_contribution_bal_type_id
99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
102: l_pen_sal_bal_type_id
103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
104: l_balance_feed_Id

Line 101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;

97: pqp_pension_types_f.ee_contribution_bal_type_id%TYPE;
98: l_er_contribution_bal_type_id
99: pqp_pension_types_f.er_contribution_bal_type_id%TYPE;
100: l_ee_retro_bal_id pay_balance_types.balance_type_id%TYPE;
101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
102: l_pen_sal_bal_type_id
103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
104: l_balance_feed_Id
105: pay_balance_feeds_f.balance_feed_id%TYPE;

Line 114: l_balance_name pay_balance_types.balance_name%TYPE;

110: l_formula_text1 VARCHAR2(32767);
111: l_tax_si_text VARCHAR2(32767);
112: l_abs_text VARCHAR2(32767);
113: l_dbi_user_name ff_database_items.user_name%TYPE;
114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 238: FROM pay_balance_types

234: -- Cursor added to find the balance name for the
235: -- Pension Salary Balance for
236: CURSOR csr_get_pen_sal_bal_name (c_bal_type_id NUMBER) IS
237: SELECT balance_name
238: FROM pay_balance_types
239: WHERE balance_type_id = c_bal_type_id
240: AND (business_group_id = p_business_group_id
241: OR business_group_id IS NULL
242: OR legislation_code = 'NL');

Line 255: FROM pay_balance_types_tl

251:
252: CURSOR c_get_retro_bal_id(c_subcat IN varchar2
253: ,c_ee_er IN varchar2) IS
254: SELECT balance_type_id
255: FROM pay_balance_types_tl
256: WHERE balance_name = 'Retro '||c_subcat||' '
257: ||c_ee_er||' Contribution'
258: AND language = 'US';
259:

Line 523: pay_balance_types_tl pbtl

519: from pay_balance_feeds_v pbf,
520: pay_balance_classifications bc,
521: pay_element_classifications pec,
522: pay_element_classifications_tl pect,
523: pay_balance_types_tl pbtl
524: where nvl(pbf.balance_initialization_flag,'N') = 'N'
525: and nvl(pbf.business_group_id,
526: p_business_group_id) = p_business_group_id
527: and nvl(pbf.legislation_code, 'NL') = 'NL'

Line 541: FROM pay_balance_types

537: order by pbf.element_name;
538: --
539: CURSOR c2_balance_type IS
540: SELECT balance_type_id
541: FROM pay_balance_types
542: WHERE business_group_id = p_business_group_id
543: AND balance_name IN (p_scheme_prefix||' Pension Salary');
544: BEGIN
545: hr_utility.set_location('Entering: '||l_proc_name, 10);