APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_BALANCE_TYPES

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

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

Line 368: l_balance_name pay_balance_types.balance_name%TYPE;

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

Line 485: from pay_balance_types

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

Line 552: pay_balance_types_tl pbtl

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

Line 571: from pay_balance_types

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