DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F2_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 352: from fnd_segment_attribute_values

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'

Line 372: from fnd_segment_attribute_values

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'