APPS.PYIEEXC dependencies on FND_NUMBER

Line 190: Select to_date('01-01-' || to_char( fnd_number.canonical_to_number(

186: begin
187: /* select the start of the financial year - if the owning action is
188: * before this or for a different payroll then its expired
189: */
190: Select to_date('01-01-' || to_char( fnd_number.canonical_to_number(
191: to_char( BACT.effective_date,'YYYY'))
192: + decode(sign( BACT.effective_date - to_date('01-01-'
193: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
194: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

Line 399: Select to_date('01-01-' || to_char((fnd_number.canonical_to_number(

395: begin
396: /* select the start of the financial year - if the owning action is
397: * before this or for a different payroll then its expired
398: */
399: Select to_date('01-01-' || to_char((fnd_number.canonical_to_number(
400: to_char( BACT.effective_date,'YYYY')) - 1)
401: + decode(sign( BACT.effective_date - to_date('01-01-'
402: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
403: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

Line 464: select to_date('01-01-' || to_char(( fnd_number.canonical_to_number(

460: p_asg_action in number)
461: is
462: l_tax_year_start date;
463: begin
464: select to_date('01-01-' || to_char(( fnd_number.canonical_to_number(
465: to_char( PPA.effective_date,'YYYY'))- 1) -- Bug 5070091 Offset payroll change
466: + decode(sign( PPA.effective_date - to_date('01-01-'
467: || to_char(PPA.effective_date,'YYYY'),'DD-MM-YYYY')),
468: -1,-1,0)),'DD-MM-YYYY') finyear