APPS.PAY_VOID_PAYMENTS dependencies on FND_NUMBER

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

25: l_end_assignment number;
26: --
27: CURSOR overlap_csr IS
28: SELECT void_pa.effective_date,
29: fnd_number.canonical_to_number(chq_or_mag_aa.serial_number) cheque_number,
30: chq_or_mag_aa.assignment_action_id
31: FROM pay_assignment_actions chq_or_mag_aa,
32: pay_action_interlocks,
33: pay_assignment_actions void_aa,

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

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

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

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

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

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