[Home] [Help]
218: WHERE organization_id=(SELECT segment1
219: FROM hr_soft_coding_keyflex
220: WHERE soft_coding_keyflex_id =
221: (SELECT soft_coding_keyflex_id
222: FROM per_all_assignments_f
223: WHERE assignment_id=p_assignment_id
224: AND p_paydate BETWEEN effective_start_date
225: AND effective_end_date));
226: