[Home] [Help]
6263: Cursor c_max_pact_dt(p_assignment_id in number,
6264: p_session_date in date) is
6265: select max(effective_date)
6266: from pay_payroll_actions ppa,
6267: pay_assignment_actions paa,
6268: per_assignments_f paf
6269: where paf.assignment_id = p_assignment_id
6270: and paf.assignment_id = paa.assignment_id
6271: and paa.payroll_action_id = ppa.payroll_action_id