APPS.PQP_NL_PENSION_TEMPLATE dependencies on FF_DATABASE_ITEMS

Line 365: l_dbi_user_name ff_database_items.user_name%TYPE;

361: l_formula_text varchar2(32767);
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: --

Line 367: l_balance_dbi_name ff_database_items.user_name%TYPE;

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
371: select element_type_id

Line 448: from ff_database_items dbi

444: and template_type = 'U';
445:
446: cursor csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
447: select user_name
448: from ff_database_items dbi
449: ,ff_route_parameter_values rpv
450: ,ff_route_parameters rp
451: ,pay_balance_dimensions pbd
452: ,pay_defined_balances pdb

Line 466: from ff_database_items dbi

462: -- cursor added to find the dbi name for the Pension Salary Balance for ABP
463:
464: cursor csr_get_pen_sal_bal_dbi_name (c_bal_type_id NUMBER) IS
465: select user_name
466: from ff_database_items dbi
467: ,ff_route_parameter_values rpv
468: ,ff_route_parameters rp
469: ,pay_balance_dimensions pbd
470: ,pay_defined_balances pdb