APPS.PAY_SG_IRAS_ARCHIVE dependencies on FND_NUMBER

Line 640: -- Bug 10326903, added fnd_number.canonical_to_number

636: and pbd.balance_dimension_id = pdb.balance_dimension_id
637: and pbd.dimension_name = '_PER_LE_YTD'
638: order by pbt.balance_name asc;
639: --
640: -- Bug 10326903, added fnd_number.canonical_to_number
641: cursor benefit_inkind_bal is
642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502

Line 642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500

638: order by pbt.balance_name asc;
639: --
640: -- Bug 10326903, added fnd_number.canonical_to_number
641: cursor benefit_inkind_bal is
642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507

Line 643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501

639: --
640: -- Bug 10326903, added fnd_number.canonical_to_number
641: cursor benefit_inkind_bal is
642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508

Line 644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502

640: -- Bug 10326903, added fnd_number.canonical_to_number
641: cursor benefit_inkind_bal is
642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509

Line 645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506

641: cursor benefit_inkind_bal is
642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510

Line 646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507

642: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(1).balance_value), --A8A_MOA_500
643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511

Line 647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508

643: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(2).balance_value), --A8A_MOA_501
644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512

Line 648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509

644: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(3).balance_value), --A8A_MOA_502
645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513

Line 649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510

645: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(7).balance_value), --A8A_MOA_506
646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514

Line 650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511

646: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(8).balance_value), --A8A_MOA_507
647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516

Line 651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512

647: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(9).balance_value), --A8A_MOA_508
648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525

Line 652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513

648: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(10).balance_value),--A8A_MOA_509
649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526

Line 653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514

649: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(11).balance_value),--A8A_MOA_510
650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527

Line 654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516

650: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(12).balance_value),--A8A_MOA_511
651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528

Line 655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525

651: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(13).balance_value),--A8A_MOA_512
652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529

Line 656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526

652: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(14).balance_value),--A8A_MOA_513
653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530

Line 657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527

653: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(15).balance_value),--A8A_MOA_514
654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531

Line 658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528

654: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(17).balance_value),--A8A_MOA_516
655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532

Line 659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529

655: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(26).balance_value),--A8A_MOA_525
656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533

Line 660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530

656: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(27).balance_value),--A8A_MOA_526
657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534

Line 661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531

657: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(28).balance_value),--A8A_MOA_527
658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
665: from per_people_extra_info pae

Line 662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532

658: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(29).balance_value),--A8A_MOA_528
659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
665: from per_people_extra_info pae
666: where person_id = p_person_id

Line 663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533

659: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(30).balance_value),--A8A_MOA_529
660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
665: from per_people_extra_info pae
666: where person_id = p_person_id
667: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'

Line 664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534

660: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(31).balance_value),--A8A_MOA_530
661: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(32).balance_value),--A8A_MOA_531
662: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(33).balance_value),--A8A_MOA_532
663: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(34).balance_value),--A8A_MOA_533
664: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(35).balance_value) --A8A_MOA_534
665: from per_people_extra_info pae
666: where person_id = p_person_id
667: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'
668: and pei_information1 = g_basis_year;

Line 670: -- Bug 10326903, added fnd_number.canonical_to_number

666: where person_id = p_person_id
667: and information_type = 'HR_A8A_BENEFITS_IN_KIND_SG'
668: and pei_information1 = g_basis_year;
669: --
670: -- Bug 10326903, added fnd_number.canonical_to_number
671: cursor furniture_exp_bal is
672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306

Line 672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304

668: and pei_information1 = g_basis_year;
669: --
670: -- Bug 10326903, added fnd_number.canonical_to_number
671: cursor furniture_exp_bal is
672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308

Line 673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305

669: --
670: -- Bug 10326903, added fnd_number.canonical_to_number
671: cursor furniture_exp_bal is
672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309

Line 674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306

670: -- Bug 10326903, added fnd_number.canonical_to_number
671: cursor furniture_exp_bal is
672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310

Line 675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307

671: cursor furniture_exp_bal is
672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311

Line 676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308

672: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(45).balance_value), --A8A_QTY_304
673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312

Line 677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309

673: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(46).balance_value), --A8A_QTY_305
674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313

Line 678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310

674: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(47).balance_value), --A8A_QTY_306
675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314

Line 679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311

675: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(48).balance_value), --A8A_QTY_307
676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315

Line 680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312

676: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(49).balance_value), --A8A_QTY_308
677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316

Line 681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313

677: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(50).balance_value), --A8A_QTY_309
678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317

Line 682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314

678: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(51).balance_value), --A8A_QTY_310
679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318

Line 683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315

679: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(52).balance_value), --A8A_QTY_311
680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319

Line 684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316

680: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(53).balance_value), --A8A_QTY_312
681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320

Line 685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317

681: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(54).balance_value), --A8A_QTY_313
682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517

Line 686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318

682: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(55).balance_value), --A8A_QTY_314
683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518

Line 687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319

683: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(56).balance_value), --A8A_QTY_315
684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519

Line 688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320

684: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(57).balance_value), --A8A_QTY_316
685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520

Line 689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517

685: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(58).balance_value), --A8A_QTY_317
686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521

Line 690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518

686: nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(59).balance_value), --A8A_QTY_318
687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522

Line 691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519

687: nvl(fnd_number.canonical_to_number(pei_information17),l_detailed_bal_out_tab(60).balance_value), --A8A_QTY_319
688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523

Line 692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520

688: nvl(fnd_number.canonical_to_number(pei_information18),l_detailed_bal_out_tab(61).balance_value), --A8A_QTY_320
689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524

Line 693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521

689: nvl(fnd_number.canonical_to_number(pei_information19),l_detailed_bal_out_tab(18).balance_value), --A8A_MOA_517
690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
697: from per_people_extra_info pae

Line 694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522

690: nvl(fnd_number.canonical_to_number(pei_information20),l_detailed_bal_out_tab(19).balance_value), --A8A_MOA_518
691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
697: from per_people_extra_info pae
698: where person_id = p_person_id

Line 695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523

691: nvl(fnd_number.canonical_to_number(pei_information21),l_detailed_bal_out_tab(20).balance_value), --A8A_MOA_519
692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
697: from per_people_extra_info pae
698: where person_id = p_person_id
699: and information_type ='HR_A8A_FURN_EXP_SG'

Line 696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524

692: nvl(fnd_number.canonical_to_number(pei_information22),l_detailed_bal_out_tab(21).balance_value), --A8A_MOA_520
693: nvl(fnd_number.canonical_to_number(pei_information23),l_detailed_bal_out_tab(22).balance_value), --A8A_MOA_521
694: nvl(fnd_number.canonical_to_number(pei_information24),l_detailed_bal_out_tab(23).balance_value), --A8A_MOA_522
695: nvl(fnd_number.canonical_to_number(pei_information25),l_detailed_bal_out_tab(24).balance_value), --A8A_MOA_523
696: nvl(fnd_number.canonical_to_number(pei_information26),l_detailed_bal_out_tab(25).balance_value) --A8A_MOA_524
697: from per_people_extra_info pae
698: where person_id = p_person_id
699: and information_type ='HR_A8A_FURN_EXP_SG'
700: and pei_information1 = g_basis_year;

Line 702: -- Bug 10326903, added fnd_number.canonical_to_number

698: where person_id = p_person_id
699: and information_type ='HR_A8A_FURN_EXP_SG'
700: and pei_information1 = g_basis_year;
701: --
702: -- Bug 10326903, added fnd_number.canonical_to_number
703: cursor hotel_accom_bal is
704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323

Line 704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321

700: and pei_information1 = g_basis_year;
701: --
702: -- Bug 10326903, added fnd_number.canonical_to_number
703: cursor hotel_accom_bal is
704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325

Line 705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322

701: --
702: -- Bug 10326903, added fnd_number.canonical_to_number
703: cursor hotel_accom_bal is
704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326

Line 706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323

702: -- Bug 10326903, added fnd_number.canonical_to_number
703: cursor hotel_accom_bal is
704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327

Line 707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324

703: cursor hotel_accom_bal is
704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328

Line 708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325

704: select nvl(fnd_number.canonical_to_number(pei_information2), l_detailed_bal_out_tab(62).balance_value), --A8A_QTY_321
705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539

Line 709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326

705: nvl(fnd_number.canonical_to_number(pei_information3), l_detailed_bal_out_tab(63).balance_value), --A8A_QTY_322
706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300

Line 710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327

706: nvl(fnd_number.canonical_to_number(pei_information4), l_detailed_bal_out_tab(64).balance_value), --A8A_QTY_323
707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301

Line 711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328

707: nvl(fnd_number.canonical_to_number(pei_information5), l_detailed_bal_out_tab(65).balance_value), --A8A_QTY_324
708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302

Line 712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539

708: nvl(fnd_number.canonical_to_number(pei_information6), l_detailed_bal_out_tab(66).balance_value), --A8A_QTY_325
709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303

Line 713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300

709: nvl(fnd_number.canonical_to_number(pei_information7), l_detailed_bal_out_tab(67).balance_value), --A8A_QTY_326
710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505

Line 714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301

710: nvl(fnd_number.canonical_to_number(pei_information8), l_detailed_bal_out_tab(68).balance_value), --A8A_QTY_327
711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088

Line 715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302

711: nvl(fnd_number.canonical_to_number(pei_information9), l_detailed_bal_out_tab(69).balance_value), --A8A_QTY_328
712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
719: from per_people_extra_info pae

Line 716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303

712: nvl(fnd_number.canonical_to_number(pei_information10),l_detailed_bal_out_tab(40).balance_value), --A8A_MOA_539
713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
719: from per_people_extra_info pae
720: where person_id = p_person_id

Line 717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505

713: nvl(fnd_number.canonical_to_number(pei_information11),l_detailed_bal_out_tab(41).balance_value), --A8A_QTY_300
714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
719: from per_people_extra_info pae
720: where person_id = p_person_id
721: and information_type ='HR_A8A_HOTEL_ACCOM_SG'

Line 718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088

714: nvl(fnd_number.canonical_to_number(pei_information12),l_detailed_bal_out_tab(42).balance_value), --A8A_QTY_301
715: nvl(fnd_number.canonical_to_number(pei_information13),l_detailed_bal_out_tab(43).balance_value), --A8A_QTY_302
716: nvl(fnd_number.canonical_to_number(pei_information14),l_detailed_bal_out_tab(44).balance_value), --A8A_QTY_303
717: nvl(fnd_number.canonical_to_number(pei_information15),l_detailed_bal_out_tab(6).balance_value) --A8A_MOA_505
718: , nvl(fnd_number.canonical_to_number(pei_information16),l_detailed_bal_out_tab(70).balance_value) --A8A_QTY_329, bug 5435088
719: from per_people_extra_info pae
720: where person_id = p_person_id
721: and information_type ='HR_A8A_HOTEL_ACCOM_SG'
722: and pei_information1 = g_basis_year;

Line 4012: is -- Bug 10326903, added fnd_number.canonical_to_number

4008: cursor shares_details
4009: ( c_person_id per_all_people_f.person_id%type,
4010: c_basis_start date,
4011: c_basis_end date )
4012: is -- Bug 10326903, added fnd_number.canonical_to_number
4013: select distinct pei.person_extra_info_id,
4014: pei.pei_information1 stock_option,
4015: fnd_number.canonical_to_number(pei.pei_information3) exercise_price,
4016: fnd_number.canonical_to_number(pei.pei_information4) market_exercise_value,

Line 4015: fnd_number.canonical_to_number(pei.pei_information3) exercise_price,

4011: c_basis_end date )
4012: is -- Bug 10326903, added fnd_number.canonical_to_number
4013: select distinct pei.person_extra_info_id,
4014: pei.pei_information1 stock_option,
4015: fnd_number.canonical_to_number(pei.pei_information3) exercise_price,
4016: fnd_number.canonical_to_number(pei.pei_information4) market_exercise_value,
4017: to_char(fnd_date.canonical_to_date(pei.pei_information5),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(pei.pei_information5),'MM')||'/'||
4018: to_char(fnd_date.canonical_to_date(pei.pei_information5),'DD') exercise_date,
4019: fnd_number.canonical_to_number(pei.pei_information6) shares_acquired,

Line 4016: fnd_number.canonical_to_number(pei.pei_information4) market_exercise_value,

4012: is -- Bug 10326903, added fnd_number.canonical_to_number
4013: select distinct pei.person_extra_info_id,
4014: pei.pei_information1 stock_option,
4015: fnd_number.canonical_to_number(pei.pei_information3) exercise_price,
4016: fnd_number.canonical_to_number(pei.pei_information4) market_exercise_value,
4017: to_char(fnd_date.canonical_to_date(pei.pei_information5),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(pei.pei_information5),'MM')||'/'||
4018: to_char(fnd_date.canonical_to_date(pei.pei_information5),'DD') exercise_date,
4019: fnd_number.canonical_to_number(pei.pei_information6) shares_acquired,
4020: hoi1.org_information1 name_of_company,

Line 4019: fnd_number.canonical_to_number(pei.pei_information6) shares_acquired,

4015: fnd_number.canonical_to_number(pei.pei_information3) exercise_price,
4016: fnd_number.canonical_to_number(pei.pei_information4) market_exercise_value,
4017: to_char(fnd_date.canonical_to_date(pei.pei_information5),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(pei.pei_information5),'MM')||'/'||
4018: to_char(fnd_date.canonical_to_date(pei.pei_information5),'DD') exercise_date,
4019: fnd_number.canonical_to_number(pei.pei_information6) shares_acquired,
4020: hoi1.org_information1 name_of_company,
4021: hoi1.org_information4 RCB,
4022: hoi1.org_information15 company_type,
4023: fnd_number.canonical_to_number(pei2.pei_information2) market_grant_value,

Line 4023: fnd_number.canonical_to_number(pei2.pei_information2) market_grant_value,

4019: fnd_number.canonical_to_number(pei.pei_information6) shares_acquired,
4020: hoi1.org_information1 name_of_company,
4021: hoi1.org_information4 RCB,
4022: hoi1.org_information15 company_type,
4023: fnd_number.canonical_to_number(pei2.pei_information2) market_grant_value,
4024: pei2.pei_information5 grant_type,
4025: decode(pei2.pei_information3, null, null, to_char(fnd_date.canonical_to_date(pei2.pei_information3),'YYYY')||'/'||
4026: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
4027: fnd_number.canonical_to_number(pei2.pei_information4) shares_granted

Line 4027: fnd_number.canonical_to_number(pei2.pei_information4) shares_granted

4023: fnd_number.canonical_to_number(pei2.pei_information2) market_grant_value,
4024: pei2.pei_information5 grant_type,
4025: decode(pei2.pei_information3, null, null, to_char(fnd_date.canonical_to_date(pei2.pei_information3),'YYYY')||'/'||
4026: to_char(fnd_date.canonical_to_date(pei2.pei_information3),'MM')||'/'||to_char(fnd_date.canonical_to_date(pei2.pei_information3),'DD')) grant_date,
4027: fnd_number.canonical_to_number(pei2.pei_information4) shares_granted
4028: from per_all_people_f pap,
4029: per_people_extra_info pei,
4030: per_people_extra_info pei2,
4031: hr_all_organization_units hou,

Line 5027: l_year :=fnd_number.canonical_to_number(substr(l_payer_id, 1, 4));

5023: end if;
5024: elsif l_payer_id_type = '8' then /* bug 16032637*/
5025: if length(l_payer_id) = 10 then
5026: if check_is_number(substr(l_payer_id, 1, 4)) then
5027: l_year :=fnd_number.canonical_to_number(substr(l_payer_id, 1, 4));
5028: end if;
5029: if ((l_year >= 1900 and l_year < 4712) and
5030: check_is_number(substr(l_payer_id, 5, 5)) and
5031: not check_is_number(substr(l_payer_id, 10, 1))) or