DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on FND_NUMBER

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