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_DATE

Line 904: l_time_worked_from := fnd_date.date_to_canonical(GREATEST(l_temp_end_date,l_hired_from));

900: -- *****************************************************************************
901:
902: IF l_time_worked_from IS NULL
903: THEN
904: l_time_worked_from := fnd_date.date_to_canonical(GREATEST(l_temp_end_date,l_hired_from));
905: END IF;
906:
907: IF l_time_worked_to IS NULL
908: THEN

Line 909: l_time_worked_to := fnd_date.date_to_canonical(l_temp_start_date);

905: END IF;
906:
907: IF l_time_worked_to IS NULL
908: THEN
909: l_time_worked_to := fnd_date.date_to_canonical(l_temp_start_date);
910: END IF;
911:
912: -- *****************************************************************************
913: --logger ('g_assignment_id ', g_assignment_id);

Line 1727: ,p_action_information6 => fnd_date.date_to_canonical

1723: ,p_action_information2 => 'WTC_PERSON1'
1724: ,p_action_information3 => l_person_number
1725: ,p_action_information4 => l_last_name
1726: ,p_action_information5 => l_first_name
1727: ,p_action_information6 => fnd_date.date_to_canonical
1728: (l_hired_from)
1729: ,p_action_information7 => fnd_date.date_to_canonical
1730: (l_hired_to)
1731: ,p_action_information8 => l_still_employed

Line 1729: ,p_action_information7 => fnd_date.date_to_canonical

1725: ,p_action_information4 => l_last_name
1726: ,p_action_information5 => l_first_name
1727: ,p_action_information6 => fnd_date.date_to_canonical
1728: (l_hired_from)
1729: ,p_action_information7 => fnd_date.date_to_canonical
1730: (l_hired_to)
1731: ,p_action_information8 => l_still_employed
1732: ,p_action_information9 => l_absence_from
1733: ,p_action_information10 => l_absence_to

Line 1770: --fnd_date.date_to_canonical(l_permanent_date)

1766: ,p_action_information2 => 'WTC_PERSON2'
1767: ,p_action_information3 => l_continuous_offer
1768: ,p_action_information4 => l_permanent_check_box
1769: ,p_action_information5 => l_permanent_date_from
1770: --fnd_date.date_to_canonical(l_permanent_date)
1771: , p_action_information6 => l_time_limited_check_box
1772: ,p_action_information7 => l_time_limited_from
1773: --fnd_date.date_to_canonical(l_time_limited_from)
1774: , p_action_information8 => l_time_limited_to

Line 1773: --fnd_date.date_to_canonical(l_time_limited_from)

1769: ,p_action_information5 => l_permanent_date_from
1770: --fnd_date.date_to_canonical(l_permanent_date)
1771: , p_action_information6 => l_time_limited_check_box
1772: ,p_action_information7 => l_time_limited_from
1773: --fnd_date.date_to_canonical(l_time_limited_from)
1774: , p_action_information8 => l_time_limited_to
1775: --fnd_date.date_to_canonical(l_time_limited_to)
1776: , p_action_information9 => l_other_check_box
1777: ,p_action_information10 => l_other

Line 1775: --fnd_date.date_to_canonical(l_time_limited_to)

1771: , p_action_information6 => l_time_limited_check_box
1772: ,p_action_information7 => l_time_limited_from
1773: --fnd_date.date_to_canonical(l_time_limited_from)
1774: , p_action_information8 => l_time_limited_to
1775: --fnd_date.date_to_canonical(l_time_limited_to)
1776: , p_action_information9 => l_other_check_box
1777: ,p_action_information10 => l_other
1778: ,p_action_information11 => l_full_time_check_box
1779: ,p_action_information12 => l_full_time

Line 1786: --fnd_date.date_to_canonical(l_decline_date)

1782: ,p_action_information15 => l_working_percentage
1783: ,p_action_information16 => l_various_working_time
1784: ,p_action_information17 => l_offer_accepted
1785: ,p_action_information18 => l_decline_date
1786: --fnd_date.date_to_canonical(l_decline_date)
1787: , p_action_information19 => l_time_worked_from
1788: --fnd_date.date_to_canonical (l_time_worked_from)
1789: , p_action_information20 => l_time_worked_to
1790: --fnd_date.date_to_canonical (l_time_worked_to)

Line 1788: --fnd_date.date_to_canonical (l_time_worked_from)

1784: ,p_action_information17 => l_offer_accepted
1785: ,p_action_information18 => l_decline_date
1786: --fnd_date.date_to_canonical(l_decline_date)
1787: , p_action_information19 => l_time_worked_from
1788: --fnd_date.date_to_canonical (l_time_worked_from)
1789: , p_action_information20 => l_time_worked_to
1790: --fnd_date.date_to_canonical (l_time_worked_to)
1791: , p_action_information21 => l_total_worked_hours
1792: ,p_action_information22 => l_paid_sick_leave_days

Line 1790: --fnd_date.date_to_canonical (l_time_worked_to)

1786: --fnd_date.date_to_canonical(l_decline_date)
1787: , p_action_information19 => l_time_worked_from
1788: --fnd_date.date_to_canonical (l_time_worked_from)
1789: , p_action_information20 => l_time_worked_to
1790: --fnd_date.date_to_canonical (l_time_worked_to)
1791: , p_action_information21 => l_total_worked_hours
1792: ,p_action_information22 => l_paid_sick_leave_days
1793: ,p_action_information23 => l_teaching_load
1794: ,p_action_information24 => l_aggrmnt_of_compn_signed -- EOY 2008

Line 2738: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)

2734: ,action_information4 emp_last_name
2735: ,action_information5 emp_first_name
2736: -- ,ACTION_INFORMATION6 HIRED_FROM
2737: -- ,ACTION_INFORMATION7 HIRED_TO
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

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 2745: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information7)

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
2748:
2749: ,action_information8 still_employed

Line 2751: --,TO_CHAR (fnd_date.canonical_to_date (action_information9)

2747: -- ) hired_to
2748:
2749: ,action_information8 still_employed
2750:
2751: --,TO_CHAR (fnd_date.canonical_to_date (action_information9)
2752: -- ,'YYYY-MM-DD'
2753: --) absence_from
2754: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2755: --,'YYYY-MM-DD'

Line 2754: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)

2750:
2751: --,TO_CHAR (fnd_date.canonical_to_date (action_information9)
2752: -- ,'YYYY-MM-DD'
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

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 2767: --,fnd_date.canonical_to_date(ACTION_INFORMATION16) NOTIFICATION_DATE

2763: ,action_information14 employed_temp_work
2764: ,action_information15 reason
2765:
2766: --,ACTION_INFORMATION16 NOTIFICATION_DATE
2767: --,fnd_date.canonical_to_date(ACTION_INFORMATION16) NOTIFICATION_DATE
2768: --,TO_CHAR (fnd_date.canonical_to_date (action_information16)
2769: --,'YYYY-MM-DD'
2770: --) notification_date
2771:

Line 2768: --,TO_CHAR (fnd_date.canonical_to_date (action_information16)

2764: ,action_information15 reason
2765:
2766: --,ACTION_INFORMATION16 NOTIFICATION_DATE
2767: --,fnd_date.canonical_to_date(ACTION_INFORMATION16) 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

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 2792: --,TO_CHAR (fnd_date.canonical_to_date (action_information5)

2788: IS
2789: SELECT action_information3 continuous_offer
2790: ,action_information4 permanent_check
2791: -- ,ACTION_INFORMATION5 PERMANENT_DATE
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

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 2802: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)

2798: ,action_information6 time_limited_check
2799:
2800: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM
2801: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO
2802: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2803: --,'YYYY-MM-DD'
2804: --) time_limited_from
2805: --,TO_CHAR (fnd_date.canonical_to_date (action_information8)
2806: --,'YYYY-MM-DD'

Line 2805: --,TO_CHAR (fnd_date.canonical_to_date (action_information8)

2801: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO
2802: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2803: --,'YYYY-MM-DD'
2804: --) 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

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 2824: --, TO_CHAR (fnd_date.canonical_to_date (NVL(action_information18,NULL))

2820: ,action_information17 offer_accepted
2821: -- ,ACTION_INFORMATION18 DECLINE_DATE
2822: -- ,ACTION_INFORMATION19 TIME_WORKED_FROM
2823: -- ,ACTION_INFORMATION20 TIME_WORKED_TO
2824: --, TO_CHAR (fnd_date.canonical_to_date (NVL(action_information18,NULL))
2825: --,'YYYY-MM-DD'
2826: --) decline_date
2827: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2828: --,'YYYY-MM-DD'

Line 2827: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))

2823: -- ,ACTION_INFORMATION20 TIME_WORKED_TO
2824: --, TO_CHAR (fnd_date.canonical_to_date (NVL(action_information18,NULL))
2825: --,'YYYY-MM-DD'
2826: --) decline_date
2827: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2828: --,'YYYY-MM-DD'
2829: --) time_worked_from
2830: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information20,NULL))
2831: --,'YYYY-MM-DD'

Line 2830: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information20,NULL))

2826: --) decline_date
2827: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2828: --,'YYYY-MM-DD'
2829: --) time_worked_from
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

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 2885: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)

2881: SELECT action_information3 holiday_duty
2882: ,action_information4 lay_off_period_paid_days
2883: ,action_information5 holiday_laid_off
2884:
2885: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2886: --,'YYYY-MM-DD'
2887: --) lay_off_from
2888: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2889: --,'YYYY-MM-DD'

Line 2888: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)

2884:
2885: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2886: --,'YYYY-MM-DD'
2887: --) lay_off_from
2888: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2889: --,'YYYY-MM-DD'
2890: --) lay_off_to
2891: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2892: -- ,ACTION_INFORMATION7 LAY_OFF_TO

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