DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PAY_LEGISLATION_RULES

Line 352: pay_legislation_rules LEG,

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

Line 392: pay_legislation_rules LEG,

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