APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_BALANCE_DIMENSIONS

Line 75: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;

71:
72: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
73: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;
74: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
75: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
76:
77:
78:
79:

Line 298: FROM pay_balance_dimensions

294: IS
295:
296: CURSOR csr_id_baldmn IS
297: SELECT balance_dimension_id
298: FROM pay_balance_dimensions
299: WHERE dimension_name = p_dimension_name
300: AND ((business_group_id is null and legislation_code is null)
301: OR
302: (legislation_code is null and business_group_id + 0 =

Line 307: l_bd_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;

303: p_frm_business_group_id)
304: OR
305: (business_group_id is null and legislation_code = 'GB'));
306:
307: l_bd_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
308:
309: BEGIN
310: --
311: FOR csr_id_baldmn_rec IN csr_id_baldmn LOOP