APPS.PYIEEXC dependencies on FND_NUMBER

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

104: begin
105: /* select the start of the financial year - if the owning action is
106: * before this or for a different payroll then its expired
107: */
108: Select to_date('01-01-' || to_char( fnd_number.canonical_to_number(
109: to_char( BACT.effective_date,'YYYY'))
110: + decode(sign( BACT.effective_date - to_date('01-01-'
111: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
112: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

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

230: begin
231: /* select the start of the financial year - if the owning action is
232: * before this or for a different payroll then its expired
233: */
234: Select to_date('01-01-' || to_char((fnd_number.canonical_to_number(
235: to_char( BACT.effective_date,'YYYY')) - 1)
236: + decode(sign( BACT.effective_date - to_date('01-01-'
237: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
238: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

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

267: p_asg_action in number)
268: is
269: l_tax_year_start date;
270: begin
271: select to_date('01-01-' || to_char(( fnd_number.canonical_to_number(
272: to_char( PPA.effective_date,'YYYY'))- 1) -- Bug 5070091 Offset payroll change
273: + decode(sign( PPA.effective_date - to_date('01-01-'
274: || to_char(PPA.effective_date,'YYYY'),'DD-MM-YYYY')),
275: -1,-1,0)),'DD-MM-YYYY') finyear