DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on FND_ID_FLEX_STRUCTURES

Line 145: fnd_id_flex_structures fstruct,

141: SELECT target.segment2 , ASSIGN.business_group_id
142: FROM
143: hr_soft_coding_keyflex target,
144: per_all_assignments ASSIGN,
145: fnd_id_flex_structures fstruct,
146: pay_legislation_rules leg,
147: pay_assignment_actions pac
148: WHERE fstruct.id_flex_num = leg.rule_mode
149: AND fstruct.id_flex_code = 'SCL'

Line 347: fnd_id_flex_structures fstruct,

343: SELECT nvl(target.segment8, '1')
344: FROM
345: hr_soft_coding_keyflex target,
346: per_all_assignments ASSIGN,
347: fnd_id_flex_structures fstruct,
348: pay_legislation_rules leg,
349: pay_assignment_actions pac
350: WHERE fstruct.id_flex_num = leg.rule_mode
351: AND fstruct.id_flex_code = 'SCL'

Line 431: fnd_id_flex_structures fstruct,

427: SELECT nvl(target.segment13,'N')
428: FROM
429: hr_soft_coding_keyflex target,
430: per_all_assignments ASSIGN,
431: fnd_id_flex_structures fstruct,
432: pay_legislation_rules leg,
433: pay_assignment_actions pac
434: WHERE fstruct.id_flex_num = leg.rule_mode
435: AND fstruct.id_flex_code = 'SCL'

Line 472: fnd_id_flex_structures fstruct,

468: SELECT target.segment2
469: FROM
470: hr_soft_coding_keyflex target,
471: per_all_assignments_f ASSIGN,
472: fnd_id_flex_structures fstruct,
473: pay_legislation_rules leg
474: WHERE fstruct.id_flex_num = leg.rule_mode
475: AND fstruct.id_flex_code = 'SCL'
476: AND fstruct.application_id = 800