6750: where plr.legislation_code = leg_code
6751: and plr.rule_type = 'CWK_S'
6752: and exists
6753: (select null
6754: from fnd_segment_attribute_values fsav
6755: where fsav.id_flex_num = plr.rule_mode
6756: and fsav.application_id = 800
6757: and fsav.id_flex_code = 'SCL'
6758: and fsav.segment_attribute_type = 'ASSIGNMENT'
6771: where legislation_code = leg_code
6772: and rule_type = 'S'
6773: and exists
6774: (select null
6775: from fnd_segment_attribute_values
6776: where id_flex_num = rule_mode
6777: and application_id = 800
6778: and id_flex_code = 'SCL'
6779: and segment_attribute_type = 'ASSIGNMENT'