APPS.PQP_NL_PGGM_TEMPLATE dependencies on FF_DATABASE_ITEMS

Line 201: l_dbi_user_name ff_database_items.user_name%TYPE;

197: l_formula_text VARCHAR2(32767);
198: l_formula_text1 VARCHAR2(32767);
199: l_tax_si_text VARCHAR2(32767);
200: l_abs_text VARCHAR2(32767);
201: l_dbi_user_name ff_database_items.user_name%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 203: l_balance_dbi_name ff_database_items.user_name%TYPE;

199: l_tax_si_text VARCHAR2(32767);
200: l_abs_text VARCHAR2(32767);
201: l_dbi_user_name ff_database_items.user_name%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 305: FROM ff_database_items dbi

301: AND template_type = 'U';
302:
303: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
304: SELECT user_name
305: FROM ff_database_items dbi
306: ,ff_route_parameter_values rpv
307: ,ff_route_parameters rp
308: ,pay_balance_dimensions pbd
309: ,pay_defined_balances pdb

Line 325: FROM ff_database_items dbi

321: -- Cursor added to find the dbi name for the
322: -- Pension Salary Balance for ABP
323: CURSOR csr_get_pen_sal_bal_dbi_name (c_bal_type_id NUMBER) IS
324: SELECT user_name
325: FROM ff_database_items dbi
326: ,ff_route_parameter_values rpv
327: ,ff_route_parameters rp
328: ,pay_balance_dimensions pbd
329: ,pay_defined_balances pdb