eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PYGBEXC dependencies on FND_NUMBER

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

163: else -- [ check expiry
164: /* select the start of the financial year - if the owning action is
165: * before this or for a different payroll then its expired
166: */
167: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
168: to_char( PTP.regular_payment_date,'YYYY'))
169: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
170: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
171: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

Line 222: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(

218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);
221:
222: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
223: to_char( PTP.regular_payment_date,'YYYY'))
224: + decode(sign( PTP.regular_payment_date -
225: to_date('06-04-'|| to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
226: -1,0,1)),'DD-MM-YYYY') finyear_end

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

271: else -- [ check expiry
272: /* select the start of the financial year - if the owning action is
273: * before this or for a different payroll then its expired
274: */
275: Select to_date('01-04-' || to_char( fnd_number.canonical_to_number(
276: to_char( PTP.regular_payment_date,'YYYY'))
277: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
278: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
279: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id

Line 329: SELECT to_date('31-03-' ||to_char(fnd_number.canonical_to_number(

325: hr_utility.set_location ('In Overloaded ASG_PEN_YTD_EC',10);
326: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
327: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
328:
329: SELECT to_date('31-03-' ||to_char(fnd_number.canonical_to_number(
330: to_char( PTP.regular_payment_date,'YYYY'))
331: + decode(sign( PTP.regular_payment_date -
332: to_date('01-04-'|| to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
333: -1,0,1)),'DD-MM-YYYY') finyear_end

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

364: p_expiry_information out nocopy number -- dimension expired flag.
365: ) is
366: l_tax_year_start date;
367: begin
368: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
369: to_char( p_user_effective_date,'YYYY'))
370: + decode(sign( p_user_effective_date - to_date('06-04-'
371: || to_char( p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
372: -1,-1,0)),'DD-MM-YYYY')

Line 404: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(

400: hr_utility.set_location ('In Overloaded ASG_STAT_YTD_EC',10);
401: hr_utility.set_location ('Namish:p_owner_assignment_action_id:'||p_owner_assignment_action_id,10);
402: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
403:
404: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
405: to_char( p_owner_effective_date,'YYYY'))
406: + decode(sign(p_owner_effective_date -
407: to_date('06-04-'|| to_char(p_owner_effective_date,'YYYY'),'DD-MM-YYYY')),
408: -1,0,1)),'DD-MM-YYYY') finyear_end

Line 524: l_frequency := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR

520: l_start_reset := INSTR(p_dimension_name,'RESET',30);
521:
522: l_start_dd_mon := SUBSTR(p_dimension_name, l_start_reset - 6, 5);
523:
524: l_frequency := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR
525: (p_dimension_name, l_start_reset + 6, 2));
526:
527: p_expiry_information := hr_gbbal.span_end(l_owning_regular_payment_date
528: ,l_frequency

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

576: -- latest balances on 11/mar/02.
577: --
578: if p_dimension_name IN ('_ASG_TD_ODD_TWO_YTD','_PER_TD_ODD_TWO_YTD') then
579: --
580: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
581: to_char( PTP.regular_payment_date,'YYYY'))
582: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
583: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
584: -1,-1,0) -

Line 586: fnd_number.canonical_to_number(

582: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
583: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
584: -1,-1,0) -
585: mod(
586: fnd_number.canonical_to_number(
587: to_char( PTP.regular_payment_date,'YYYY'))
588: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
589: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
590: -1,-1,0),2)

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

596: and PTP.time_period_id = BACT.time_period_id;
597: --
598: elsif p_dimension_name in ('_ASG_TD_EVEN_TWO_YTD','_PER_TD_EVEN_TWO_YTD') then
599: --
600: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
601: to_char( PTP.regular_payment_date,'YYYY'))
602: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
603: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
604: -1,-1,0) -

Line 606: fnd_number.canonical_to_number(

602: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
603: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
604: -1,-1,0) -
605: mod(
606: fnd_number.canonical_to_number(
607: to_char( PTP.regular_payment_date,'YYYY'))
608: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
609: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
610: -1,0,-1),2)

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

655: hr_utility.set_location ('IN ASG_PROC_TWO_YTD_EC',10);
656: hr_utility.set_location ('p_dimension_name'||p_dimension_name,10);
657: hr_utility.set_location ('p_owner_payroll_action_id'||p_owner_payroll_action_id,10);
658:
659: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
660: to_char( PTP.regular_payment_date,'YYYY'))
661: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
662: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
663: -1,-1,0)),'DD-MM-YYYY') finyear

Line 695: p_expiry_information := to_date('06-04-' || to_char(fnd_number.canonical_to_number(

691: END IF;
692: --
693: END IF;
694:
695: p_expiry_information := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
696: to_char(l_tax_year_start,'yyyy')) + l_adjust)
697: ,'DD-MM-YYYY') - 1;
698:
699: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

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

772: p_asg_action in number)
773: is
774: l_tax_year_start date;
775: begin
776: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
777: to_char( PTP.regular_payment_date,'YYYY'))
778: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
779: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
780: -1,-1,0)),'DD-MM-YYYY') finyear

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

812: l_tax_year_start date;
813: l_odd_tax_year_start date;
814: l_odd_adjust number;
815: begin
816: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
817: to_char( PTP.regular_payment_date,'YYYY'))
818: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
819: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
820: -1,-1,0)),'DD-MM-YYYY') finyear

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

834: -- The start of tax year is in an EVEN year, must subtract 1
835: l_odd_adjust := 1;
836: END IF;
837: --
838: l_odd_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
839: to_char(l_tax_year_start,'yyyy')) - l_odd_adjust)
840: ,'DD-MM-YYYY');
841: p_start_date := l_odd_tax_year_start;
842: --

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

863: l_tax_year_start date;
864: l_even_tax_year_start date;
865: l_even_adjust number;
866: begin
867: select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
868: to_char( PTP.regular_payment_date,'YYYY'))
869: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
870: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
871: -1,-1,0)),'DD-MM-YYYY') finyear

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

885: -- The start of tax year is in an ODD year, must subtract 1
886: l_even_adjust := 1;
887: END IF;
888: --
889: l_even_tax_year_start := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
890: to_char(l_tax_year_start,'yyyy')) - l_even_adjust)
891: ,'DD-MM-YYYY');
892: p_start_date := l_even_tax_year_start;
893: --

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

913: p_asg_action in number)
914: is
915: l_tax_year_start date;
916: begin
917: select to_date('01-04-' || to_char( fnd_number.canonical_to_number(
918: to_char( PTP.regular_payment_date,'YYYY'))
919: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
920: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
921: -1,-1,0)),'DD-MM-YYYY') finyear