300: WHERE balance_type_id = p_prim_bal_type_id
301: AND ((business_group_id IS NULL AND legislation_code = 'NO')
302: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
303: AND balance_dimension_id = ( select balance_dimension_id
304: from pay_balance_dimensions where legislation_code = 'NO'
305: and dimension_name = 'Assignment Calendar Year To Date' ) ;
306:
307: ---------------------------------------------------------------
308:
2002: WHERE balance_type_id = p_prim_bal_type_id
2003: AND ((business_group_id IS NULL AND legislation_code = 'NO')
2004: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
2005: AND balance_dimension_id = ( select balance_dimension_id
2006: from pay_balance_dimensions where legislation_code = 'NO'
2007: and dimension_name = 'Assignment Calendar Year To Date' ) ;
2008:
2009: ----------------------------------------------------------------------------------------------------
2010: