10376: and pgr.business_group_id = p_business_group_id
10377: and plr.rule_type = 'S'
10378: and exists
10379: (select 1
10380: from fnd_segment_attribute_values fsav
10381: where fsav.id_flex_num = plr.rule_mode
10382: and fsav.application_id = 800
10383: and fsav.id_flex_code = 'SCL'
10384: and fsav.segment_attribute_type = 'ASSIGNMENT'