DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_ABSENCE dependencies on FND_NUMBER

Line 656: AND fnd_number.canonical_to_number(p_abs_information20)<>0)

652: -- added for bug#4104220
653: IF p_abs_information18 = 'Y' THEN
654: IF p_abs_information19 IS NOT NULL
655: OR (p_abs_information20 IS NOT NULL
656: AND fnd_number.canonical_to_number(p_abs_information20)<>0)
657: OR p_abs_information5 IS NOT NULL
658: OR p_abs_information6 IS NOT NULL
659: OR p_abs_information7 IS NOT NULL
660: OR p_abs_information8 IS NOT NULL

Line 662: AND fnd_number.canonical_to_number(p_abs_information9)<>0)

658: OR p_abs_information6 IS NOT NULL
659: OR p_abs_information7 IS NOT NULL
660: OR p_abs_information8 IS NOT NULL
661: OR (p_abs_information9 IS NOT NULL
662: AND fnd_number.canonical_to_number(p_abs_information9)<>0)
663: OR (p_abs_information10 IS NOT NULL
664: AND fnd_number.canonical_to_number(p_abs_information10)<>0)
665: OR (p_abs_information11 IS NOT NULL
666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)

Line 664: AND fnd_number.canonical_to_number(p_abs_information10)<>0)

660: OR p_abs_information8 IS NOT NULL
661: OR (p_abs_information9 IS NOT NULL
662: AND fnd_number.canonical_to_number(p_abs_information9)<>0)
663: OR (p_abs_information10 IS NOT NULL
664: AND fnd_number.canonical_to_number(p_abs_information10)<>0)
665: OR (p_abs_information11 IS NOT NULL
666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)
667: OR (p_abs_information12 IS NOT NULL
668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)

Line 666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)

662: AND fnd_number.canonical_to_number(p_abs_information9)<>0)
663: OR (p_abs_information10 IS NOT NULL
664: AND fnd_number.canonical_to_number(p_abs_information10)<>0)
665: OR (p_abs_information11 IS NOT NULL
666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)
667: OR (p_abs_information12 IS NOT NULL
668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)
669: OR (p_abs_information13 IS NOT NULL
670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)

Line 668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)

664: AND fnd_number.canonical_to_number(p_abs_information10)<>0)
665: OR (p_abs_information11 IS NOT NULL
666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)
667: OR (p_abs_information12 IS NOT NULL
668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)
669: OR (p_abs_information13 IS NOT NULL
670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)
671: OR (p_abs_information14 IS NOT NULL
672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)

Line 670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)

666: AND fnd_number.canonical_to_number(p_abs_information11)<>0)
667: OR (p_abs_information12 IS NOT NULL
668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)
669: OR (p_abs_information13 IS NOT NULL
670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)
671: OR (p_abs_information14 IS NOT NULL
672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)
673: OR (p_abs_information15 IS NOT NULL
674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)

Line 672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)

668: AND fnd_number.canonical_to_number(p_abs_information12)<>0)
669: OR (p_abs_information13 IS NOT NULL
670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)
671: OR (p_abs_information14 IS NOT NULL
672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)
673: OR (p_abs_information15 IS NOT NULL
674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)
675: OR (p_abs_information16 IS NOT NULL
676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)

Line 674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)

670: AND fnd_number.canonical_to_number(p_abs_information13)<>0)
671: OR (p_abs_information14 IS NOT NULL
672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)
673: OR (p_abs_information15 IS NOT NULL
674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)
675: OR (p_abs_information16 IS NOT NULL
676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)
677: OR (p_abs_information21 IS NOT NULL
678: AND fnd_number.canonical_to_number(p_abs_information21)<>0)

Line 676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)

672: AND fnd_number.canonical_to_number(p_abs_information14)<>0)
673: OR (p_abs_information15 IS NOT NULL
674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)
675: OR (p_abs_information16 IS NOT NULL
676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)
677: OR (p_abs_information21 IS NOT NULL
678: AND fnd_number.canonical_to_number(p_abs_information21)<>0)
679: OR (p_abs_information22 IS NOT NULL
680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)

Line 678: AND fnd_number.canonical_to_number(p_abs_information21)<>0)

674: AND fnd_number.canonical_to_number(p_abs_information15)<>0)
675: OR (p_abs_information16 IS NOT NULL
676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)
677: OR (p_abs_information21 IS NOT NULL
678: AND fnd_number.canonical_to_number(p_abs_information21)<>0)
679: OR (p_abs_information22 IS NOT NULL
680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)
681: THEN
682: -- raise an error

Line 680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)

676: AND fnd_number.canonical_to_number(p_abs_information16)<>0)
677: OR (p_abs_information21 IS NOT NULL
678: AND fnd_number.canonical_to_number(p_abs_information21)<>0)
679: OR (p_abs_information22 IS NOT NULL
680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)
681: THEN
682: -- raise an error
683: hr_utility.set_message(800,'PER_75097_DIF_TRG_PLAN');
684: hr_utility.raise_error;