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.PAY_SE_WORK_TIME_CERTIFICATE dependencies on FND_NUMBER

Line 762: l_assign_working_percentage := fnd_number.canonical_to_number(lr_soft_coded_keyflex_info.segment9);

758: l_notification_date := lr_soft_coded_keyflex_info.segment5;
759: l_termination_reason := lr_soft_coded_keyflex_info.segment7;
760:
761: --Added the conversion from number to cannonical
762: l_assign_working_percentage := fnd_number.canonical_to_number(lr_soft_coded_keyflex_info.segment9);
763: --logger ('l_local_unit_id', l_local_unit_id);
764: --logger ('l_reason', l_reason);
765: --logger ('l_notification_date', l_notification_date);
766: --logger (' l_termination_reason', l_termination_reason);

Line 2702: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) hired_from

2698: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2699: --,'YYYY-MM-DD'
2700: -- ) hired_from
2701:
2702: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) hired_from
2703: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) hired_to
2704:
2705: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2706: -- ,'YYYY-MM-DD'

Line 2703: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) hired_to

2699: --,'YYYY-MM-DD'
2700: -- ) hired_from
2701:
2702: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) hired_from
2703: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) hired_to
2704:
2705: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2706: -- ,'YYYY-MM-DD'
2707: -- ) hired_to

Line 2717: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information9),'YYYYMMDD')) absence_from

2713: --) absence_from
2714: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2715: --,'YYYY-MM-DD'
2716: --) absence_to
2717: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information9),'YYYYMMDD')) absence_from
2718: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information10),'YYYYMMDD')) absence_to
2719:
2720: ,action_information11 form_of_employment
2721: ,action_information12 work_taks

Line 2718: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information10),'YYYYMMDD')) absence_to

2714: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2715: --,'YYYY-MM-DD'
2716: --) absence_to
2717: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information9),'YYYYMMDD')) absence_from
2718: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information10),'YYYYMMDD')) absence_to
2719:
2720: ,action_information11 form_of_employment
2721: ,action_information12 work_taks
2722: ,action_information13 employed_temp_agency

Line 2732: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information16),'YYYYMMDD')) notification_date

2728: --,TO_CHAR (fnd_date.canonical_to_date (action_information16)
2729: --,'YYYY-MM-DD'
2730: --) notification_date
2731:
2732: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information16),'YYYYMMDD')) notification_date
2733:
2734: ,action_information17 employees_request
2735: ,action_information18 termination_reason
2736: ,action_information19 absence_percentage

Line 2737: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD'))employment_end_date

2733:
2734: ,action_information17 employees_request
2735: ,action_information18 termination_reason
2736: ,action_information19 absence_percentage
2737: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD'))employment_end_date
2738: FROM pay_action_information
2739: WHERE action_context_type = 'PA'
2740: AND action_context_id = csr_v_pa_id
2741: AND action_information_category = 'EMEA REPORT INFORMATION'

Line 2756: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information5),'YYYYMMDD')) permanent_date_from

2752: --,TO_CHAR (fnd_date.canonical_to_date (action_information5)
2753: --,'YYYY-MM-DD'
2754: --) permanent_date
2755:
2756: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information5),'YYYYMMDD')) permanent_date_from
2757: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information25),'YYYYMMDD')) permanent_date_to
2758: ,action_information6 time_limited_check
2759:
2760: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM

Line 2757: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information25),'YYYYMMDD')) permanent_date_to

2753: --,'YYYY-MM-DD'
2754: --) permanent_date
2755:
2756: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information5),'YYYYMMDD')) permanent_date_from
2757: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information25),'YYYYMMDD')) permanent_date_to
2758: ,action_information6 time_limited_check
2759:
2760: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM
2761: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO

Line 2769: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) time_limited_from

2765: --,TO_CHAR (fnd_date.canonical_to_date (action_information8)
2766: --,'YYYY-MM-DD'
2767: --) time_limited_to
2768:
2769: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) time_limited_from
2770: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information8),'YYYYMMDD')) time_limited_to
2771:
2772: ,action_information9 other_check
2773: ,action_information10 other

Line 2770: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information8),'YYYYMMDD')) time_limited_to

2766: --,'YYYY-MM-DD'
2767: --) time_limited_to
2768:
2769: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) time_limited_from
2770: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information8),'YYYYMMDD')) time_limited_to
2771:
2772: ,action_information9 other_check
2773: ,action_information10 other
2774: ,action_information11 full_time_check

Line 2794: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date

2790: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information20,NULL))
2791: --,'YYYY-MM-DD'
2792: --) time_worked_to
2793:
2794: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2795: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2797:
2798: ,action_information21 total_worked_hours

Line 2795: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from

2791: --,'YYYY-MM-DD'
2792: --) time_worked_to
2793:
2794: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2795: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2797:
2798: ,action_information21 total_worked_hours
2799: ,action_information22 paid_sick_leave_days

Line 2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to

2792: --) time_worked_to
2793:
2794: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2795: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2797:
2798: ,action_information21 total_worked_hours
2799: ,action_information22 paid_sick_leave_days
2800: ,action_information23 teaching_load

Line 2820: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(action_information9)) salary_year

2816: ,action_information5 assign_frequency
2817: ,action_information6 assign_part_time
2818: ,action_information7 assign_working_percentage
2819: ,action_information8 assign_various_work_time
2820: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(action_information9)) salary_year
2821: ,action_information10 assign_salary_paid_out
2822: ,action_information11 salary_amount
2823: ,action_information12 school_holiday_pay_amount
2824: ,action_information13 school_holiday_pay_box

Line 2854: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) lay_off_from

2850: --) lay_off_to
2851: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2852: -- ,ACTION_INFORMATION7 LAY_OFF_TO
2853:
2854: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) lay_off_from
2855: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) lay_off_to
2856:
2857:
2858: ,action_information8 other_information

Line 2855: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) lay_off_to

2851: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2852: -- ,ACTION_INFORMATION7 LAY_OFF_TO
2853:
2854: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) lay_off_from
2855: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) lay_off_to
2856:
2857:
2858: ,action_information8 other_information
2859: ,action_information9 legal_employer_name