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.

[Home] [Help]

APPS.PAY_FR_MAP_CALC dependencies on FND_NUMBER

Line 187: and abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id);

183: and abs_information_category = 'FR_M'
184: and date_end < p_end_date
185: and date_end > p_confinement_date
186: and abs_information4 is null
187: and abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id);
188:
189: -- 1) for anti natal maternity no check is done on duration as the eligibility for
190: -- IJSS lasts until the birth.
191: -- 2) for post natal leave the duration is fetched from user_table FR_MAP_DURATION

Line 559: fnd_number.canonical_to_number(pabs.abs_information6) births,

555: cursor c_get_parent_maternity(p_parent_absence_id number) is
556: SELECT pabs.abs_information2 elig_gi,
557: nvl(fnd_date.canonical_to_date (pabs.abs_information4),
558: hr_general.end_of_time) birth_date,
559: fnd_number.canonical_to_number(pabs.abs_information6) births,
560: pabs.abs_information7 estmtd_ijss,
561: pabs.abs_information8 elig_ijss_hours,
562: fnd_number.canonical_to_number (pabs.abs_information9)
563: elig_ijss_contrib,

Line 562: fnd_number.canonical_to_number (pabs.abs_information9)

558: hr_general.end_of_time) birth_date,
559: fnd_number.canonical_to_number(pabs.abs_information6) births,
560: pabs.abs_information7 estmtd_ijss,
561: pabs.abs_information8 elig_ijss_hours,
562: fnd_number.canonical_to_number (pabs.abs_information9)
563: elig_ijss_contrib,
564: pabs.date_start abs_start,
565: pabs.date_end abs_end
566: FROM per_absence_attendances pabs

Line 579: and abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id)

575: , date_end - date_start + 1 duration
576: from per_absence_attendances
577: where person_id = p_person_id
578: and date_end <= p_max_end_date
579: and abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id)
580: order by date_start;
581:
582: TYPE t_absence is RECORD
583: (absence_id number

Line 678: g_map_calc.births := nvl(fnd_number.canonical_to_number

674: g_map_calc.parent_absence_start_date := abs_rec.date_start;
675: g_map_calc.parent_absence_end_date := abs_rec.date_end;
676: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information7;
677: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information3;
678: g_map_calc.births := nvl(fnd_number.canonical_to_number
679: (abs_rec.abs_information6),1);
680: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
681: (abs_rec.abs_information4), hr_general.end_of_time) ;
682: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;

Line 683: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number

679: (abs_rec.abs_information6),1);
680: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
681: (abs_rec.abs_information4), hr_general.end_of_time) ;
682: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;
683: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
684: (abs_rec.abs_information9) ;
685: hr_utility.set_location('INIT_MAP',50);
686:
687: else -- }{ processed absence is child fetch parent

Line 721: g_map_calc.births := nvl(fnd_number.canonical_to_number

717: g_map_calc.parent_absence_start_date := abs_rec.date_start;
718: g_map_calc.parent_absence_end_date := abs_rec.date_end;
719: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information7;
720: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information3;
721: g_map_calc.births := nvl(fnd_number.canonical_to_number
722: (abs_rec.abs_information6),1);
723: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
724: (abs_rec.abs_information4),hr_general.end_of_time);
725: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;

Line 726: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number

722: (abs_rec.abs_information6),1);
723: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
724: (abs_rec.abs_information4),hr_general.end_of_time);
725: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information8;
726: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
727: (abs_rec.abs_information9) ;
728: hr_utility.set_location('INIT_MAP',70);
729:
730: end if ; -- } fetch parent

Line 741: g_map_calc.births := nvl(fnd_number.canonical_to_number

737: g_map_calc.parent_absence_start_date := abs_rec.date_start;
738: g_map_calc.parent_absence_end_date := abs_rec.date_end;
739: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information4;
740: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information2;
741: g_map_calc.births := nvl(fnd_number.canonical_to_number
742: (abs_rec.abs_information3),1);
743: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
744: (abs_rec.abs_information1), hr_general.end_of_time) ;
745: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;

Line 746: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number

742: (abs_rec.abs_information3),1);
743: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
744: (abs_rec.abs_information1), hr_general.end_of_time) ;
745: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;
746: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
747: (abs_rec.abs_information6) ;
748: g_map_calc.SPOUSES_LEAVE := fnd_number.canonical_to_number
749: (abs_rec.abs_information7) ;
750: hr_utility.set_location('INIT_MAP',80);

Line 748: g_map_calc.SPOUSES_LEAVE := fnd_number.canonical_to_number

744: (abs_rec.abs_information1), hr_general.end_of_time) ;
745: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;
746: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
747: (abs_rec.abs_information6) ;
748: g_map_calc.SPOUSES_LEAVE := fnd_number.canonical_to_number
749: (abs_rec.abs_information7) ;
750: hr_utility.set_location('INIT_MAP',80);
751:
752: end if; -- } adoption

Line 762: g_map_calc.births := nvl(fnd_number.canonical_to_number

758: g_map_calc.parent_absence_start_date := abs_rec.date_start;
759: g_map_calc.parent_absence_end_date := abs_rec.date_end;
760: g_map_calc.ESTIMATED_IJSS := abs_rec.abs_information4;
761: g_map_calc.GI_ELIGIBLE := abs_rec.abs_information2;
762: g_map_calc.births := nvl(fnd_number.canonical_to_number
763: (abs_rec.abs_information3),1);
764: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
765: (abs_rec.abs_information1), hr_general.end_of_time) ;
766: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;

Line 767: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number

763: (abs_rec.abs_information3),1);
764: g_map_calc.birth_date := nvl(fnd_date.canonical_to_date
765: (abs_rec.abs_information1), hr_general.end_of_time) ;
766: g_map_calc.ELIG_IJSS_HOURS := abs_rec.abs_information5;
767: g_map_calc.ELIG_IJSS_CONTRIB := fnd_number.canonical_to_number
768: (abs_rec.abs_information6) ;
769: hr_utility.set_location('INIT_MAP',90);
770:
771: end if; -- } end Paternity