617: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
618:
619: cursor csr_latest_asg_act_id is
620: select max(paa.assignment_action_id)
621: from per_time_periods ptp,
622: pay_payroll_actions pact,
623: pay_assignment_actions paa
624: where paa.assignment_id = p_assignment_id
625: and paa.payroll_action_id = pact.payroll_action_id
666: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
667:
668: cursor csr_latest_asg_act_id is
669: select max(paa.assignment_action_id)
670: from per_time_periods ptp,
671: pay_payroll_actions pact,
672: pay_assignment_actions paa
673: where paa.assignment_id = p_assignment_id
674: and paa.payroll_action_id = pact.payroll_action_id