APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_BALANCE_TYPES

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

308: l_ele_new_name t_ele_name;
309: l_main_ele_name t_ele_name;
310: l_retro_ele_name t_ele_name;
311:
312: type t_bal_name is table of pay_balance_types.balance_name%type
313: index by BINARY_INTEGER;
314: l_bal_name t_bal_name;
315: l_bal_new_name t_bal_name;
316:

Line 366: l_balance_name pay_balance_types.balance_name%TYPE;

362: l_formula_text1 varchar2(32767);
363: l_tax_si_text varchar2(32767);
364: l_oht_text varchar2(32767);
365: l_dbi_user_name ff_database_items.user_name%TYPE;
366: l_balance_name pay_balance_types.balance_name%TYPE;
367: l_balance_dbi_name ff_database_items.user_name%TYPE;
368:
369: --
370: cursor csr_get_ele_info (c_ele_name varchar2) is

Line 483: from pay_balance_types

479:
480: -- cursor added to find the balance name for the Pension Salary Balance for
481: cursor csr_get_pen_sal_bal_name (c_bal_type_id NUMBER) IS
482: select balance_name
483: from pay_balance_types
484: where balance_type_id = c_bal_type_id
485: and (business_group_id = p_business_group_id
486: OR business_group_id is null
487: OR legislation_code = 'NL');

Line 550: pay_balance_types_tl pbtl

546: from pay_balance_feeds_v pbf,
547: pay_balance_classifications bc,
548: pay_element_classifications pec,
549: pay_element_classifications_tl pect,
550: pay_balance_types_tl pbtl
551: where nvl(pbf.balance_initialization_flag,'N') = 'N'
552: and nvl(pbf.business_group_id,
553: p_business_group_id) = p_business_group_id
554: and nvl(pbf.legislation_code, 'NL') = 'NL'

Line 569: from pay_balance_types

565:
566: --
567: cursor c2_balance_type is
568: select balance_type_id
569: from pay_balance_types
570: where business_group_id = p_business_group_id
571: and balance_name in (p_scheme_prefix||' Pension Salary');
572: begin
573: hr_utility.set_location('Entering: '||l_proc_name, 10);