DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PAY_LEGISLATION_RULES

Line 358: pay_legislation_rules LEG,

354: select scl.segment2
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

Line 398: pay_legislation_rules LEG,

394: CURSOR csr_get_local_unit (p_assignment_id NUMBER) IS
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