DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 773: from fnd_segment_attribute_values fsav

769: and pgr.business_group_id = p_business_group_id
770: and plr.rule_type = 'S'
771: and exists
772: (select 1
773: from fnd_segment_attribute_values fsav
774: where fsav.id_flex_num = plr.rule_mode
775: and fsav.application_id = 800
776: and fsav.id_flex_code = 'SCL'
777: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 4548: from fnd_segment_attribute_values fsav

4544: where plr.legislation_code = l_legislation_code
4545: and plr.rule_type = 'S'
4546: and exists
4547: (select 1
4548: from fnd_segment_attribute_values fsav
4549: where fsav.id_flex_num = plr.rule_mode
4550: and fsav.application_id = 800
4551: and fsav.id_flex_code = 'SCL'
4552: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 5971: from fnd_segment_attribute_values fsav

5967: where plr.legislation_code = l_legislation_code
5968: and plr.rule_type = 'S'
5969: and exists
5970: (select 1
5971: from fnd_segment_attribute_values fsav
5972: where fsav.id_flex_num = plr.rule_mode
5973: and fsav.application_id = 800
5974: and fsav.id_flex_code = 'SCL'
5975: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 10112: from fnd_segment_attribute_values fsav

10108: and pgr.business_group_id = l_business_group_id
10109: and plr.rule_type = 'S'
10110: and exists
10111: (select 1
10112: from fnd_segment_attribute_values fsav
10113: where fsav.id_flex_num = plr.rule_mode
10114: and fsav.application_id = 800
10115: and fsav.id_flex_code = 'SCL'
10116: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 11351: from fnd_segment_attribute_values fsav

11347: and pgr.business_group_id = l_business_group_id
11348: and plr.rule_type = 'CWK_S'
11349: and exists
11350: (select 1
11351: from fnd_segment_attribute_values fsav
11352: where fsav.id_flex_num = plr.rule_mode
11353: and fsav.application_id = 800
11354: and fsav.id_flex_code = 'SCL'
11355: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 16860: from fnd_segment_attribute_values fsav

16856: and pgr.business_group_id = l_business_group_id
16857: and plr.rule_type = 'S'
16858: and exists
16859: (select 1
16860: from fnd_segment_attribute_values fsav
16861: where fsav.id_flex_num = plr.rule_mode
16862: and fsav.application_id = 800
16863: and fsav.id_flex_code = 'SCL'
16864: and fsav.segment_attribute_type = 'ASSIGNMENT'

Line 19260: from fnd_segment_attribute_values fsav

19256: and pgr.business_group_id = l_business_group_id
19257: and plr.rule_type = 'S'
19258: and exists
19259: (select 1
19260: from fnd_segment_attribute_values fsav
19261: where fsav.id_flex_num = plr.rule_mode
19262: and fsav.application_id = 800
19263: and fsav.id_flex_code = 'SCL'
19264: and fsav.segment_attribute_type = 'ASSIGNMENT'