352: where legislation_code = P_LEG_CODE
353: and rule_type = 'S'
354: and exists
355: (select null
356: from fnd_segment_attribute_values
357: where id_flex_num = rule_mode
358: and application_id = 800
359: and id_flex_code = 'SCL'
360: and segment_attribute_type = 'ASSIGNMENT'
372: where legislation_code = P_LEG_CODE
373: and rule_type = 'CWK_S'
374: and exists
375: (select null
376: from fnd_segment_attribute_values
377: where id_flex_num = rule_mode
378: and application_id = 800
379: and id_flex_code = 'SCL'
380: and segment_attribute_type = 'ASSIGNMENT'