524: IS
525: BEGIN
526: INSERT
527: INTO
528: pay_element_span_usages
529: (
530: element_span_usage_id,
531: business_group_id,
532: time_span_id,
540: object_version_number
541: )
542: --values
543: SELECT
544: pay_element_span_usages_s.nextval,
545: p_business_group_id,
546: p_time_span_id,
547: p_retro_comp_usage_id,
548: p_retro_element_type_id,
559: (
560: SELECT
561: 1
562: FROM
563: pay_element_span_usages pesu
564: WHERE
565: pesu.business_group_id = p_business_group_id
566: AND pesu.legislation_code IS NULL
567: AND pesu.time_span_id = p_time_span_id