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 902: l_time_worked_from := fnd_date.date_to_canonical(GREATEST(l_temp_end_date,l_hired_from));

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

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

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

Line 1705: ,p_action_information6 => fnd_date.date_to_canonical

1701: ,p_action_information2 => 'WTC_PERSON1'
1702: ,p_action_information3 => l_person_number
1703: ,p_action_information4 => l_last_name
1704: ,p_action_information5 => l_first_name
1705: ,p_action_information6 => fnd_date.date_to_canonical
1706: (l_hired_from)
1707: ,p_action_information7 => fnd_date.date_to_canonical
1708: (l_hired_to)
1709: ,p_action_information8 => l_still_employed

Line 1707: ,p_action_information7 => fnd_date.date_to_canonical

1703: ,p_action_information4 => l_last_name
1704: ,p_action_information5 => l_first_name
1705: ,p_action_information6 => fnd_date.date_to_canonical
1706: (l_hired_from)
1707: ,p_action_information7 => fnd_date.date_to_canonical
1708: (l_hired_to)
1709: ,p_action_information8 => l_still_employed
1710: ,p_action_information9 => l_absence_from
1711: ,p_action_information10 => l_absence_to

Line 1748: --fnd_date.date_to_canonical(l_permanent_date)

1744: ,p_action_information2 => 'WTC_PERSON2'
1745: ,p_action_information3 => l_continuous_offer
1746: ,p_action_information4 => l_permanent_check_box
1747: ,p_action_information5 => l_permanent_date_from
1748: --fnd_date.date_to_canonical(l_permanent_date)
1749: , p_action_information6 => l_time_limited_check_box
1750: ,p_action_information7 => l_time_limited_from
1751: --fnd_date.date_to_canonical(l_time_limited_from)
1752: , p_action_information8 => l_time_limited_to

Line 1751: --fnd_date.date_to_canonical(l_time_limited_from)

1747: ,p_action_information5 => l_permanent_date_from
1748: --fnd_date.date_to_canonical(l_permanent_date)
1749: , p_action_information6 => l_time_limited_check_box
1750: ,p_action_information7 => l_time_limited_from
1751: --fnd_date.date_to_canonical(l_time_limited_from)
1752: , p_action_information8 => l_time_limited_to
1753: --fnd_date.date_to_canonical(l_time_limited_to)
1754: , p_action_information9 => l_other_check_box
1755: ,p_action_information10 => l_other

Line 1753: --fnd_date.date_to_canonical(l_time_limited_to)

1749: , p_action_information6 => l_time_limited_check_box
1750: ,p_action_information7 => l_time_limited_from
1751: --fnd_date.date_to_canonical(l_time_limited_from)
1752: , p_action_information8 => l_time_limited_to
1753: --fnd_date.date_to_canonical(l_time_limited_to)
1754: , p_action_information9 => l_other_check_box
1755: ,p_action_information10 => l_other
1756: ,p_action_information11 => l_full_time_check_box
1757: ,p_action_information12 => l_full_time

Line 1764: --fnd_date.date_to_canonical(l_decline_date)

1760: ,p_action_information15 => l_working_percentage
1761: ,p_action_information16 => l_various_working_time
1762: ,p_action_information17 => l_offer_accepted
1763: ,p_action_information18 => l_decline_date
1764: --fnd_date.date_to_canonical(l_decline_date)
1765: , p_action_information19 => l_time_worked_from
1766: --fnd_date.date_to_canonical (l_time_worked_from)
1767: , p_action_information20 => l_time_worked_to
1768: --fnd_date.date_to_canonical (l_time_worked_to)

Line 1766: --fnd_date.date_to_canonical (l_time_worked_from)

1762: ,p_action_information17 => l_offer_accepted
1763: ,p_action_information18 => l_decline_date
1764: --fnd_date.date_to_canonical(l_decline_date)
1765: , p_action_information19 => l_time_worked_from
1766: --fnd_date.date_to_canonical (l_time_worked_from)
1767: , p_action_information20 => l_time_worked_to
1768: --fnd_date.date_to_canonical (l_time_worked_to)
1769: , p_action_information21 => l_total_worked_hours
1770: ,p_action_information22 => l_paid_sick_leave_days

Line 1768: --fnd_date.date_to_canonical (l_time_worked_to)

1764: --fnd_date.date_to_canonical(l_decline_date)
1765: , p_action_information19 => l_time_worked_from
1766: --fnd_date.date_to_canonical (l_time_worked_from)
1767: , p_action_information20 => l_time_worked_to
1768: --fnd_date.date_to_canonical (l_time_worked_to)
1769: , p_action_information21 => l_total_worked_hours
1770: ,p_action_information22 => l_paid_sick_leave_days
1771: ,p_action_information23 => l_teaching_load
1772: ,p_action_information24 => l_aggrmnt_of_compn_signed -- EOY 2008

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

2694: ,action_information4 emp_last_name
2695: ,action_information5 emp_first_name
2696: -- ,ACTION_INFORMATION6 HIRED_FROM
2697: -- ,ACTION_INFORMATION7 HIRED_TO
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

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

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
2708:
2709: ,action_information8 still_employed

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

2707: -- ) hired_to
2708:
2709: ,action_information8 still_employed
2710:
2711: --,TO_CHAR (fnd_date.canonical_to_date (action_information9)
2712: -- ,'YYYY-MM-DD'
2713: --) absence_from
2714: -- ,TO_CHAR (fnd_date.canonical_to_date (action_information10)
2715: --,'YYYY-MM-DD'

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

2710:
2711: --,TO_CHAR (fnd_date.canonical_to_date (action_information9)
2712: -- ,'YYYY-MM-DD'
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

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

2723: ,action_information14 employed_temp_work
2724: ,action_information15 reason
2725:
2726: --,ACTION_INFORMATION16 NOTIFICATION_DATE
2727: --,fnd_date.canonical_to_date(ACTION_INFORMATION16) NOTIFICATION_DATE
2728: --,TO_CHAR (fnd_date.canonical_to_date (action_information16)
2729: --,'YYYY-MM-DD'
2730: --) notification_date
2731:

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

2724: ,action_information15 reason
2725:
2726: --,ACTION_INFORMATION16 NOTIFICATION_DATE
2727: --,fnd_date.canonical_to_date(ACTION_INFORMATION16) 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

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

2748: IS
2749: SELECT action_information3 continuous_offer
2750: ,action_information4 permanent_check
2751: -- ,ACTION_INFORMATION5 PERMANENT_DATE
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

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

2758: ,action_information6 time_limited_check
2759:
2760: -- ,ACTION_INFORMATION7 TIME_LIMITED_FROM
2761: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO
2762: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2763: --,'YYYY-MM-DD'
2764: --) time_limited_from
2765: --,TO_CHAR (fnd_date.canonical_to_date (action_information8)
2766: --,'YYYY-MM-DD'

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

2761: -- ,ACTION_INFORMATION8 TIME_LIMITED_TO
2762: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2763: --,'YYYY-MM-DD'
2764: --) 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

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

2780: ,action_information17 offer_accepted
2781: -- ,ACTION_INFORMATION18 DECLINE_DATE
2782: -- ,ACTION_INFORMATION19 TIME_WORKED_FROM
2783: -- ,ACTION_INFORMATION20 TIME_WORKED_TO
2784: --, TO_CHAR (fnd_date.canonical_to_date (NVL(action_information18,NULL))
2785: --,'YYYY-MM-DD'
2786: --) decline_date
2787: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2788: --,'YYYY-MM-DD'

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

2783: -- ,ACTION_INFORMATION20 TIME_WORKED_TO
2784: --, TO_CHAR (fnd_date.canonical_to_date (NVL(action_information18,NULL))
2785: --,'YYYY-MM-DD'
2786: --) decline_date
2787: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2788: --,'YYYY-MM-DD'
2789: --) time_worked_from
2790: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information20,NULL))
2791: --,'YYYY-MM-DD'

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

2786: --) decline_date
2787: --,TO_CHAR (fnd_date.canonical_to_date (NVL(action_information19,NULL))
2788: --,'YYYY-MM-DD'
2789: --) time_worked_from
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

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

2841: SELECT action_information3 holiday_duty
2842: ,action_information4 lay_off_period_paid_days
2843: ,action_information5 holiday_laid_off
2844:
2845: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2846: --,'YYYY-MM-DD'
2847: --) lay_off_from
2848: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2849: --,'YYYY-MM-DD'

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

2844:
2845: --,TO_CHAR (fnd_date.canonical_to_date (action_information6)
2846: --,'YYYY-MM-DD'
2847: --) lay_off_from
2848: --,TO_CHAR (fnd_date.canonical_to_date (action_information7)
2849: --,'YYYY-MM-DD'
2850: --) lay_off_to
2851: -- ,ACTION_INFORMATION6 LAY_OFF_FROM
2852: -- ,ACTION_INFORMATION7 LAY_OFF_TO

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