DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on FND_ID_FLEX_STRUCTURES

Line 353: fnd_id_flex_structures fstruct

349: from hr_soft_coding_keyflex scl,
350: pay_assignment_actions pac,
351: per_all_assignments_f ASSIGN,
352: pay_legislation_rules LEG,
353: fnd_id_flex_structures fstruct
354: Where pac.assignment_action_id = p_assignment_action_id
355: and pac.assignment_id = ASSIGN.assignment_id
356: and ASSIGN.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
357: and LEG.rule_type = 'S'

Line 393: fnd_id_flex_structures fstruct

389: select scl.segment2
390: from hr_soft_coding_keyflex scl,
391: per_all_assignments_f ASSIGN,
392: pay_legislation_rules LEG,
393: fnd_id_flex_structures fstruct
394: Where ASSIGN.assignment_id = p_assignment_id
395: and p_effective_date between ASSIGN.effective_start_date and ASSIGN.effective_end_date
396: and ASSIGN.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
397: and LEG.rule_type = 'S'