APPS.PAY_VOID_PAYMENTS dependencies on FND_NUMBER

Line 30: fnd_number.canonical_to_number(chq_or_mag_aa.serial_number) cheque_number,

26: l_no_of_chq_processed number := 0; -- for bug 9960968
27: --
28: CURSOR overlap_csr IS
29: SELECT void_pa.effective_date,
30: fnd_number.canonical_to_number(chq_or_mag_aa.serial_number) cheque_number,
31: chq_or_mag_aa.assignment_action_id
32: FROM pay_assignment_actions chq_or_mag_aa,
33: pay_action_interlocks,
34: pay_assignment_actions void_aa,

Line 39: AND fnd_number.canonical_to_number(chq_or_mag_aa.serial_number)

35: pay_payroll_actions void_pa
36: WHERE chq_or_mag_aa.payroll_action_id = p_payroll_action_id
37: AND ((l_start_cheque is not null
38: AND l_end_cheque is not null
39: AND fnd_number.canonical_to_number(chq_or_mag_aa.serial_number)
40: BETWEEN l_start_cheque AND l_end_cheque)
41: OR (l_start_cheque is null and l_start_cheque is null))
42: AND ((l_start_assignment is not null
43: AND l_end_assignment is not null

Line 55: fnd_number.canonical_to_number(act.serial_number) cheque_number,

51: --
52: CURSOR void_csr IS
53: SELECT act.assignment_action_id,
54: act.assignment_id,
55: fnd_number.canonical_to_number(act.serial_number) cheque_number,
56: act.object_version_number,
57: act.action_status,
58: act.tax_unit_id,
59: -- nvl((select distinct 'Y'

Line 76: and fnd_number.canonical_to_number(act.serial_number)

72: and act.assignment_action_id between
73: l_start_assignment and l_end_assignment))
74: AND ((l_start_cheque is not null
75: and l_end_cheque is not null
76: and fnd_number.canonical_to_number(act.serial_number)
77: BETWEEN l_start_cheque AND l_end_cheque)
78: or
79: (l_start_cheque is null and l_end_cheque is null))
80: AND act.assignment_id = asg.assignment_id