APPS.PYGBEXC dependencies on FND_NUMBER

Line 120: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

116: else -- [ check expiry
117: /* select the start of the financial year - if the owning action is
118: * before this or for a different payroll then its expired
119: */
120: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
121: to_char( PTP.regular_payment_date,'YYYY'))
122: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
123: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
124: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

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

186: else -- [ check expiry
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-04-' || to_char( fnd_number.canonical_to_number(
191: to_char( PTP.regular_payment_date,'YYYY'))
192: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
193: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
194: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

Line 247: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

243: p_expiry_information out nocopy number -- dimension expired flag.
244: ) is
245: l_tax_year_start date;
246: begin
247: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
248: to_char( p_user_effective_date,'YYYY'))
249: + decode(sign( p_user_effective_date - to_date('06-04-'
250: || to_char( p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
251: -1,-1,0)),'DD-MM-YYYY')

Line 373: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

369: -- latest balances on 11/mar/02.
370: --
371: if p_dimension_name IN ('_ASG_TD_ODD_TWO_YTD','_PER_TD_ODD_TWO_YTD') then
372: --
373: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
374: to_char( PTP.regular_payment_date,'YYYY'))
375: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
376: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
377: -1,-1,0) -

Line 379: fnd_number.canonical_to_number(

375: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
376: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
377: -1,-1,0) -
378: mod(
379: fnd_number.canonical_to_number(
380: to_char( PTP.regular_payment_date,'YYYY'))
381: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
382: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
383: -1,-1,0),2)

Line 393: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

389: and PTP.time_period_id = BACT.time_period_id;
390: --
391: elsif p_dimension_name in ('_ASG_TD_EVEN_TWO_YTD','_PER_TD_EVEN_TWO_YTD') then
392: --
393: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
394: to_char( PTP.regular_payment_date,'YYYY'))
395: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
396: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
397: -1,-1,0) -

Line 399: fnd_number.canonical_to_number(

395: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
396: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
397: -1,-1,0) -
398: mod(
399: fnd_number.canonical_to_number(
400: to_char( PTP.regular_payment_date,'YYYY'))
401: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
402: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
403: -1,0,-1),2)

Line 500: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

496: p_asg_action in number)
497: is
498: l_tax_year_start date;
499: begin
500: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
501: to_char( PTP.regular_payment_date,'YYYY'))
502: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
503: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
504: -1,-1,0)),'DD-MM-YYYY') finyear

Line 540: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

536: l_tax_year_start date;
537: l_odd_tax_year_start date;
538: l_odd_adjust number;
539: begin
540: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
541: to_char( PTP.regular_payment_date,'YYYY'))
542: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
543: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
544: -1,-1,0)),'DD-MM-YYYY') finyear

Line 562: l_odd_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(

558: -- The start of tax year is in an EVEN year, must subtract 1
559: l_odd_adjust := 1;
560: END IF;
561: --
562: l_odd_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
563: to_char(l_tax_year_start,'yyyy')) - l_odd_adjust)
564: ,'DD-MM-YYYY');
565: p_start_date := l_odd_tax_year_start;
566: --

Line 591: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

587: l_tax_year_start date;
588: l_even_tax_year_start date;
589: l_even_adjust number;
590: begin
591: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
592: to_char( PTP.regular_payment_date,'YYYY'))
593: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
594: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
595: -1,-1,0)),'DD-MM-YYYY') finyear

Line 613: l_even_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(

609: -- The start of tax year is in an ODD year, must subtract 1
610: l_even_adjust := 1;
611: END IF;
612: --
613: l_even_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
614: to_char(l_tax_year_start,'yyyy')) - l_even_adjust)
615: ,'DD-MM-YYYY');
616: p_start_date := l_even_tax_year_start;
617: --

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

637: p_asg_action in number)
638: is
639: l_tax_year_start date;
640: begin
641: select to_date('01-04-' || to_char( fnd_number.canonical_to_number(
642: to_char( PTP.regular_payment_date,'YYYY'))
643: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
644: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
645: -1,-1,0)),'DD-MM-YYYY') finyear