Line 56: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
52: ,p_balance_name IN pay_balance_types.balance_name%TYPE
53: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
54: ,p_till_date IN DATE) RETURN number IS
55: CURSOR cur_assignment_action is 56: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')|| 57: paa.assignment_action_id),16))
58: FROM pay_assignment_actions paa
59: ,pay_payroll_actions ppa
60: WHERE paa.assignment_id=p_assignment_id