APPS.PAY_HK_BAL_UPLOAD dependencies on FND_NUMBER

Line 93: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

89: (
90: p_assignment_id number
91: ,p_upload_date date
92: ) is
93: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
94: to_char(p_upload_date,'YYYY'))+ decode(sign(p_upload_date
95: - to_date('01-04-'||to_char(p_upload_date,'YYYY'),'DD-MM-YYYY'))
96: ,-1,-1,0)),'DD-MM-YYYY')
97: from per_assignments_f ASS