348: where legislation_code = P_LEG_CODE
349: and rule_type = 'S'
350: and exists
351: (select null
352: from fnd_segment_attribute_values
353: where id_flex_num = rule_mode
354: and application_id = 800
355: and id_flex_code = 'SCL'
356: and segment_attribute_type = 'ASSIGNMENT'
368: where legislation_code = P_LEG_CODE
369: and rule_type = 'CWK_S'
370: and exists
371: (select null
372: from fnd_segment_attribute_values
373: where id_flex_num = rule_mode
374: and application_id = 800
375: and id_flex_code = 'SCL'
376: and segment_attribute_type = 'ASSIGNMENT'