367: FROM pay_element_span_usages pesu,
368: pay_retro_component_usages prcu
369: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
370: AND retro_component_id = ( SELECT retro_component_id
371: FROM pay_retro_components
372: WHERE legislation_code = 'NL'
373: AND short_name = 'Adjustment'
374: AND component_name = 'Adjustment')
375: AND creator_type = 'ET'
765: FROM pay_element_span_usages pesu,
766: pay_retro_component_usages prcu
767: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
768: AND retro_component_id = ( SELECT retro_component_id
769: FROM pay_retro_components
770: WHERE legislation_code = 'NL'
771: AND short_name = 'Adjustment'
772: AND component_name = 'Adjustment')
773: AND creator_type = 'ET'