APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on FF_DATABASE_ITEMS

Line 130: l_dbi_user_name ff_database_items.user_name%TYPE;

126: l_formula_text VARCHAR2(32767);
127: l_formula_text1 VARCHAR2(32767);
128: l_tax_si_text VARCHAR2(32767);
129: l_abs_text VARCHAR2(32767);
130: l_dbi_user_name ff_database_items.user_name%TYPE;
131: l_balance_name pay_balance_types.balance_name%TYPE;
132: l_balance_dbi_name ff_database_items.user_name%TYPE;
133: l_template_id pay_shadow_element_types.template_id%TYPE;
134: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 132: l_balance_dbi_name ff_database_items.user_name%TYPE;

128: l_tax_si_text VARCHAR2(32767);
129: l_abs_text VARCHAR2(32767);
130: l_dbi_user_name ff_database_items.user_name%TYPE;
131: l_balance_name pay_balance_types.balance_name%TYPE;
132: l_balance_dbi_name ff_database_items.user_name%TYPE;
133: l_template_id pay_shadow_element_types.template_id%TYPE;
134: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
135: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
136: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 245: FROM ff_database_items dbi

241: AND template_type = 'U';
242:
243: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS
244: SELECT user_name
245: FROM ff_database_items dbi
246: ,ff_route_parameter_values rpv
247: ,ff_route_parameters rp
248: ,pay_balance_dimensions pbd
249: ,pay_defined_balances pdb

Line 261: FROM ff_database_items dbi

257: AND rpv.value = pdb.DEFINED_BALANCE_ID;
258:
259: CURSOR csr_get_dbi_asg_user_name (c_bal_type_id NUMBER) IS
260: SELECT user_name
261: FROM ff_database_items dbi
262: ,ff_route_parameter_values rpv
263: ,ff_route_parameters rp
264: ,pay_balance_dimensions pbd
265: ,pay_defined_balances pdb