APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 363: type t_bal_name is table of pay_balance_types.balance_name%type

359: l_ele_new_name t_ele_name;
360: l_main_ele_name t_ele_name;
361: l_retro_ele_name t_ele_name;
362:
363: type t_bal_name is table of pay_balance_types.balance_name%type
364: index by BINARY_INTEGER;
365: l_bal_name t_bal_name;
366: l_bal_new_name t_bal_name;
367:

Line 586: from pay_balance_types

582: order by pbf.element_name;
583: --
584: cursor c2_balance_type is
585: select balance_type_id
586: from pay_balance_types
587: where business_group_id = p_business_group_id
588: and balance_name in (p_scheme_prefix||' Pension Salary');
589: begin
590: hr_utility.set_location('Entering: '||l_proc_name, 10);