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
626: and pact.time_period_id = ptp.time_period_id
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
675: and pact.time_period_id = ptp.time_period_id