APPS.PQP_NL_ABP_TEMPLATE dependencies on FF_DATABASE_ITEMS

Line 113: l_dbi_user_name ff_database_items.user_name%TYPE;

109: l_formula_text VARCHAR2(32767);
110: l_formula_text1 VARCHAR2(32767);
111: l_tax_si_text VARCHAR2(32767);
112: l_abs_text VARCHAR2(32767);
113: l_dbi_user_name ff_database_items.user_name%TYPE;
114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 115: l_balance_dbi_name ff_database_items.user_name%TYPE;

111: l_tax_si_text VARCHAR2(32767);
112: l_abs_text VARCHAR2(32767);
113: l_dbi_user_name ff_database_items.user_name%TYPE;
114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 202: FROM ff_database_items dbi

198: AND template_type = 'U';
199:
200: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
201: SELECT user_name
202: FROM ff_database_items dbi
203: ,ff_route_parameter_values rpv
204: ,ff_route_parameters rp
205: ,pay_balance_dimensions pbd
206: ,pay_defined_balances pdb

Line 220: FROM ff_database_items dbi

216: -- Cursor added to find the dbi name for the
217: -- Pension Salary Balance for ABP
218: CURSOR csr_get_pen_sal_bal_dbi_name (c_bal_type_id NUMBER) IS
219: SELECT user_name
220: FROM ff_database_items dbi
221: ,ff_route_parameter_values rpv
222: ,ff_route_parameters rp
223: ,pay_balance_dimensions pbd
224: ,pay_defined_balances pdb