APPS.PQP_NL_PENSION_TEMPLATE dependencies on FF_DATABASE_ITEMS

Line 367: l_dbi_user_name ff_database_items.user_name%TYPE;

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

Line 369: l_balance_dbi_name ff_database_items.user_name%TYPE;

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

Line 450: from ff_database_items dbi

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

Line 468: from ff_database_items dbi

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