DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on FND_ID_FLEX_STRUCTURES

Line 359: fnd_id_flex_structures fstruct

355: from hr_soft_coding_keyflex scl,
356: pay_assignment_actions pac,
357: per_all_assignments_f ASSIGN,
358: pay_legislation_rules LEG,
359: fnd_id_flex_structures fstruct
360: Where pac.assignment_action_id = p_assignment_action_id
361: and pac.assignment_id = ASSIGN.assignment_id
362: and ASSIGN.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
363: and LEG.rule_type = 'S'

Line 399: fnd_id_flex_structures fstruct

395: select scl.segment2
396: from hr_soft_coding_keyflex scl,
397: per_all_assignments_f ASSIGN,
398: pay_legislation_rules LEG,
399: fnd_id_flex_structures fstruct
400: Where ASSIGN.assignment_id = p_assignment_id
401: and p_effective_date between ASSIGN.effective_start_date and ASSIGN.effective_end_date
402: and ASSIGN.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
403: and LEG.rule_type = 'S'