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 764: l_assign_working_percentage := fnd_number.canonical_to_number(lr_soft_coded_keyflex_info.segment9);

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

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

2738: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2739: --,'YYYY-MM-DD'
2740: -- ) hired_from
2741:
2742: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) hired_from
2743: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) hired_to
2744:
2745: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2746: -- ,'YYYY-MM-DD'

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

2739: --,'YYYY-MM-DD'
2740: -- ) hired_from
2741:
2742: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) hired_from
2743: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) hired_to
2744:
2745: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2746: -- ,'YYYY-MM-DD'
2747: -- ) hired_to

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

2753: --) absence_from
2754: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2755: --,'YYYY-MM-DD'
2756: --) absence_to
2757: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information9),'YYYYMMDD')) absence_from
2758: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information10),'YYYYMMDD')) absence_to
2759:
2760: ,action_information11 form_of_employment
2761: ,action_information12 work_taks

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

2754: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2755: --,'YYYY-MM-DD'
2756: --) absence_to
2757: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information9),'YYYYMMDD')) absence_from
2758: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information10),'YYYYMMDD')) absence_to
2759:
2760: ,action_information11 form_of_employment
2761: ,action_information12 work_taks
2762: ,action_information13 employed_temp_agency

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

2768: --,TO_CHAR (fnd_date.canonical_to_date (action_information16)
2769: --,'YYYY-MM-DD'
2770: --) notification_date
2771:
2772: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information16),'YYYYMMDD')) notification_date
2773:
2774: ,action_information17 employees_request
2775: ,action_information18 termination_reason
2776: ,action_information19 absence_percentage

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

2773:
2774: ,action_information17 employees_request
2775: ,action_information18 termination_reason
2776: ,action_information19 absence_percentage
2777: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD'))employment_end_date
2778: FROM pay_action_information
2779: WHERE action_context_type = 'PA'
2780: AND action_context_id = csr_v_pa_id
2781: AND action_information_category = 'EMEA REPORT INFORMATION'

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

2792: --,TO_CHAR (fnd_date.canonical_to_date (action_information5)
2793: --,'YYYY-MM-DD'
2794: --) permanent_date
2795:
2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information5),'YYYYMMDD')) permanent_date_from
2797: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information25),'YYYYMMDD')) permanent_date_to
2798: ,action_information6 time_limited_check
2799:
2800: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM

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

2793: --,'YYYY-MM-DD'
2794: --) permanent_date
2795:
2796: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information5),'YYYYMMDD')) permanent_date_from
2797: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information25),'YYYYMMDD')) permanent_date_to
2798: ,action_information6 time_limited_check
2799:
2800: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM
2801: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO

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

2805: --,TO_CHAR (fnd_date.canonical_to_date (action_information8)
2806: --,'YYYY-MM-DD'
2807: --) time_limited_to
2808:
2809: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) time_limited_from
2810: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information8),'YYYYMMDD')) time_limited_to
2811:
2812: ,action_information9 other_check
2813: ,action_information10 other

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

2806: --,'YYYY-MM-DD'
2807: --) time_limited_to
2808:
2809: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) time_limited_from
2810: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information8),'YYYYMMDD')) time_limited_to
2811:
2812: ,action_information9 other_check
2813: ,action_information10 other
2814: ,action_information11 full_time_check

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

2830: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information20,NULL))
2831: --,'YYYY-MM-DD'
2832: --) time_worked_to
2833:
2834: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2835: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2836: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2837:
2838: ,action_information21 total_worked_hours

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

2831: --,'YYYY-MM-DD'
2832: --) time_worked_to
2833:
2834: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2835: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2836: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2837:
2838: ,action_information21 total_worked_hours
2839: ,action_information22 paid_sick_leave_days

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

2832: --) time_worked_to
2833:
2834: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information18),'YYYYMMDD')) decline_date
2835: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information19),'YYYYMMDD')) time_worked_from
2836: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD')) time_worked_to
2837:
2838: ,action_information21 total_worked_hours
2839: ,action_information22 paid_sick_leave_days
2840: ,action_information23 teaching_load

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

2856: ,action_information5 assign_frequency
2857: ,action_information6 assign_part_time
2858: ,action_information7 assign_working_percentage
2859: ,action_information8 assign_various_work_time
2860: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(action_information9)) salary_year
2861: ,action_information10 assign_salary_paid_out
2862: ,action_information11 salary_amount
2863: ,action_information12 school_holiday_pay_amount
2864: ,action_information13 school_holiday_pay_box

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

2890: --) lay_off_to
2891: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2892: -- ,ACTION_INFORMATION7 LAY_OFF_TO
2893:
2894: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) lay_off_from
2895: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) lay_off_to
2896:
2897:
2898: ,action_information8 other_information

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

2891: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2892: -- ,ACTION_INFORMATION7 LAY_OFF_TO
2893:
2894: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information6),'YYYYMMDD')) lay_off_from
2895: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information7),'YYYYMMDD')) lay_off_to
2896:
2897:
2898: ,action_information8 other_information
2899: ,action_information9 legal_employer_name