DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 1334: from fnd_segment_attribute_values fsav

1330: and pgr.business_group_id = p_business_group_id
1331: and plr.rule_type = 'S'
1332: and exists
1333: (select 1
1334: from fnd_segment_attribute_values fsav
1335: where to_char(fsav.id_flex_num) = plr.rule_mode -- Fix For Bug # 12813119
1336: and fsav.application_id = 800
1337: and fsav.id_flex_code = 'SCL'
1338: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 5115: from fnd_segment_attribute_values fsav

5111: where plr.legislation_code = l_legislation_code
5112: and plr.rule_type = 'S'
5113: and exists
5114: (select 1
5115: from fnd_segment_attribute_values fsav
5116: where to_char(fsav.id_flex_num) = plr.rule_mode -- Fix For Bug 12813119
5117: and fsav.application_id = 800
5118: and fsav.id_flex_code = 'SCL'
5119: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 6538: from fnd_segment_attribute_values fsav

6534: where plr.legislation_code = l_legislation_code
6535: and plr.rule_type = 'S'
6536: and exists
6537: (select 1
6538: from fnd_segment_attribute_values fsav
6539: where to_char(fsav.id_flex_num) = plr.rule_mode --Fix For Bug 12813119
6540: and fsav.application_id = 800
6541: and fsav.id_flex_code = 'SCL'
6542: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 10679: from fnd_segment_attribute_values fsav

10675: and pgr.business_group_id = l_business_group_id
10676: and plr.rule_type = 'S'
10677: and exists
10678: (select 1
10679: from fnd_segment_attribute_values fsav
10680: where fsav.id_flex_num = plr.rule_mode
10681: and fsav.application_id = 800
10682: and fsav.id_flex_code = 'SCL'
10683: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 11952: from fnd_segment_attribute_values fsav

11948: and pgr.business_group_id = l_business_group_id
11949: and plr.rule_type = 'CWK_S'
11950: and exists
11951: (select 1
11952: from fnd_segment_attribute_values fsav
11953: where to_char(fsav.id_flex_num) = plr.rule_mode --Fix For Bug 12813119
11954: and fsav.application_id = 800
11955: and fsav.id_flex_code = 'SCL'
11956: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 17706: from fnd_segment_attribute_values fsav

17702: and pgr.business_group_id = l_business_group_id
17703: and plr.rule_type = 'S'
17704: and exists
17705: (select 1
17706: from fnd_segment_attribute_values fsav
17707: where to_char(fsav.id_flex_num) = plr.rule_mode -- Fix For Bug# 12813119
17708: and fsav.application_id = 800
17709: and fsav.id_flex_code = 'SCL'
17710: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 20123: from fnd_segment_attribute_values fsav

20119: and pgr.business_group_id = l_business_group_id
20120: and plr.rule_type = 'S'
20121: and exists
20122: (select 1
20123: from fnd_segment_attribute_values fsav
20124: where to_char(fsav.id_flex_num) = plr.rule_mode -- Fix For Bug# 12813119
20125: and fsav.application_id = 800
20126: and fsav.id_flex_code = 'SCL'
20127: and fsav.segment_attribute_type = 'ASSIGNMENT'