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_NO_EERR_CONTINUOUS dependencies on FND_DATE

Line 144: fnd_date.canonical_to_date (

140: select pay_no_eerr_continuous.get_parameter (
141: legislative_parameters,
142: 'LEGAL_EMPLOYER'
143: ),
144: fnd_date.canonical_to_date (
145: pay_no_eerr_continuous.get_parameter (
146: legislative_parameters,
147: 'REPORT_START_DATE'
148: )

Line 150: fnd_date.canonical_to_date (

146: legislative_parameters,
147: 'REPORT_START_DATE'
148: )
149: ),
150: fnd_date.canonical_to_date (
151: pay_no_eerr_continuous.get_parameter (
152: legislative_parameters,
153: 'REPORT_END_DATE'
154: )

Line 575: select fnd_date.canonical_to_date(segment24)

571: /* Cursor to get the Position Code for the passed soft coding keyflex id */
572: cursor csr_get_latest_st_date_scl (
573: p_soft_coding_keyflex_id number
574: ) is
575: select fnd_date.canonical_to_date(segment24)
576: /* fnd_date.canonical_to_date(nvl(segment24,'0001/01/01'))*/
577: from hr_soft_coding_keyflex
578: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
579:

Line 576: /* fnd_date.canonical_to_date(nvl(segment24,'0001/01/01'))*/

572: cursor csr_get_latest_st_date_scl (
573: p_soft_coding_keyflex_id number
574: ) is
575: select fnd_date.canonical_to_date(segment24)
576: /* fnd_date.canonical_to_date(nvl(segment24,'0001/01/01'))*/
577: from hr_soft_coding_keyflex
578: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
579:
580: l_new_latest_start_date date ;

Line 624: select fnd_date.canonical_to_date (peev.screen_entry_value)

620: c_input_val_name varchar2,
621: c_assignment_id number,
622: c_eff_date date
623: ) is
624: select fnd_date.canonical_to_date (peev.screen_entry_value)
625: from pay_element_types_f pet,
626: pay_input_values_f piv,
627: pay_element_entries_f peef,
628: pay_element_entry_values_f peev

Line 1099: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');

1095: l_prev_hour_eff_date := null;
1096: l_lu_change_flag := 'N';
1097: l_local_unit_org_no := i.local_unit_org_no ;
1098: l_retrospective_hire_flag := 'N';
1099: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');
1100: l_new_latest_start_date := null;
1101: --
1102: --
1103: /* Get the Start Date */

Line 1200: p_action_information14 => fnd_date.date_to_canonical(

1196: p_action_information7 => j.person_id,
1197: p_action_information8 => j.national_identifier,
1198: p_action_information9 => j.full_name,
1199: p_action_information10 => j.employee_number,
1200: p_action_information14 => fnd_date.date_to_canonical(
1201: collemptable (4).temination_date),
1202: p_action_information21 => collemptable (4).status_type,
1203: p_assignment_id => j.assignment_id
1204: );

Line 1352: p_action_information11 => fnd_date.date_to_canonical(

1348: p_action_information7 => j.person_id,
1349: p_action_information8 => j.national_identifier,
1350: p_action_information9 => j.full_name,
1351: p_action_information10 => j.employee_number,
1352: p_action_information11 => fnd_date.date_to_canonical(
1353: collemptable (1).start_date),
1354: p_action_information12 => fnd_number.number_to_canonical(
1355: collemptable (1).working_hours),
1356: p_action_information17 => collemptable (1).job_id,

Line 1644: p_action_information11 => fnd_date.date_to_canonical(collemptable (

1640: p_action_information9 => j.full_name -- Full Name
1641: ,
1642: p_action_information10 => j.employee_number -- Employee Number
1643: ,
1644: p_action_information11 => fnd_date.date_to_canonical(collemptable (
1645: cnt
1646: ).start_date) -- Employment Start Date
1647: --,p_action_information16 => p_time_period_id
1648: ,

Line 1653: p_action_information13 => fnd_date.date_to_canonical(collemptable (

1649: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
1650: cnt
1651: ).working_hours) -- Weekly Working Hours
1652: ,
1653: p_action_information13 => fnd_date.date_to_canonical(collemptable (
1654: cnt
1655: ).hour_date_change) -- Date of change of hours
1656: ,
1657: p_action_information14 => fnd_date.date_to_canonical(collemptable (

Line 1657: p_action_information14 => fnd_date.date_to_canonical(collemptable (

1653: p_action_information13 => fnd_date.date_to_canonical(collemptable (
1654: cnt
1655: ).hour_date_change) -- Date of change of hours
1656: ,
1657: p_action_information14 => fnd_date.date_to_canonical(collemptable (
1658: cnt
1659: ).temination_date) -- Employment Termination Date
1660: ,
1661: p_action_information15 => collemptable (

Line 1665: p_action_information16 => fnd_date.date_to_canonical(collemptable (

1661: p_action_information15 => collemptable (
1662: cnt
1663: ).lu_value -- Local Unit Org No
1664: ,
1665: p_action_information16 => fnd_date.date_to_canonical(collemptable (
1666: cnt
1667: ).lu_change_date) -- Local Unit Change Date
1668: ,
1669: p_action_information17 => collemptable (

Line 1673: p_action_information18 =>fnd_date.date_to_canonical( collemptable (

1669: p_action_information17 => collemptable (
1670: cnt
1671: ).job_id -- Occupation
1672: ,
1673: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
1674: cnt
1675: ).job_change_date) -- Occupation change date
1676: ,
1677: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

Line 1677: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

1673: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
1674: cnt
1675: ).job_change_date) -- Occupation change date
1676: ,
1677: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
1678: ,
1679: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1680: p_action_information21 => collemptable (
1681: cnt

Line 1679: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),

1675: ).job_change_date) -- Occupation change date
1676: ,
1677: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
1678: ,
1679: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1680: p_action_information21 => collemptable (
1681: cnt
1682: ).status_type,
1683: p_action_information22 => fnd_date.date_to_canonical(collemptable (

Line 1683: p_action_information22 => fnd_date.date_to_canonical(collemptable (

1679: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1680: p_action_information21 => collemptable (
1681: cnt
1682: ).status_type,
1683: p_action_information22 => fnd_date.date_to_canonical(collemptable (
1684: cnt
1685: ).corrected_start_date),
1686: p_action_information23 => collemptable (cnt).rev_temination,
1687: p_assignment_id => j.assignment_id

Line 1976: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');

1972: l_retrospective_hire_flag := 'Y' ;
1973: l_retrospective_date := l_detailed_output(cnt).effective_date;
1974:
1975: else
1976: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');
1977: end if;
1978:
1979: else
1980: if l_Emp_start_Date <> l_detailed_output (cnt).effective_date then

Line 2692: p_action_information11 => fnd_date.date_to_canonical(collemptable (

2688: p_action_information9 => j.full_name -- Full Name
2689: ,
2690: p_action_information10 => j.employee_number -- Employee Number
2691: ,
2692: p_action_information11 => fnd_date.date_to_canonical(collemptable (
2693: cnt
2694: ).start_date) -- Employment Start Date
2695: --,p_action_information16 => p_time_period_id
2696: ,

Line 2701: p_action_information13 => fnd_date.date_to_canonical(collemptable (

2697: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
2698: cnt
2699: ).working_hours) -- Weekly Working Hours
2700: ,
2701: p_action_information13 => fnd_date.date_to_canonical(collemptable (
2702: cnt
2703: ).hour_date_change) -- Date of change of hours
2704: ,
2705: p_action_information14 => fnd_date.date_to_canonical(collemptable (

Line 2705: p_action_information14 => fnd_date.date_to_canonical(collemptable (

2701: p_action_information13 => fnd_date.date_to_canonical(collemptable (
2702: cnt
2703: ).hour_date_change) -- Date of change of hours
2704: ,
2705: p_action_information14 => fnd_date.date_to_canonical(collemptable (
2706: cnt
2707: ).temination_date) -- Employment Termination Date
2708: ,
2709: p_action_information15 => collemptable (

Line 2713: p_action_information16 => fnd_date.date_to_canonical(collemptable (

2709: p_action_information15 => collemptable (
2710: cnt
2711: ).lu_value -- Local Unit Org No
2712: ,
2713: p_action_information16 => fnd_date.date_to_canonical(collemptable (
2714: cnt
2715: ).lu_change_date) -- Local Unit Change Date
2716: ,
2717: p_action_information17 => collemptable (

Line 2721: p_action_information18 =>fnd_date.date_to_canonical( collemptable (

2717: p_action_information17 => collemptable (
2718: cnt
2719: ).job_id -- Occupation
2720: ,
2721: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
2722: cnt
2723: ).job_change_date) -- Occupation change date
2724: ,
2725: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

Line 2725: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

2721: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
2722: cnt
2723: ).job_change_date) -- Occupation change date
2724: ,
2725: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
2726: ,
2727: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2728: p_action_information21 => collemptable (
2729: cnt

Line 2727: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),

2723: ).job_change_date) -- Occupation change date
2724: ,
2725: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
2726: ,
2727: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2728: p_action_information21 => collemptable (
2729: cnt
2730: ).status_type,
2731: p_action_information22 => fnd_date.date_to_canonical(collemptable (

Line 2731: p_action_information22 => fnd_date.date_to_canonical(collemptable (

2727: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2728: p_action_information21 => collemptable (
2729: cnt
2730: ).status_type,
2731: p_action_information22 => fnd_date.date_to_canonical(collemptable (
2732: cnt
2733: ).corrected_start_date),
2734: p_action_information23 => collemptable (cnt).rev_temination,
2735: p_assignment_id => j.assignment_id

Line 3003: fnd_date.canonical_to_date(action_information11) action_information11,

2999: ) is
3000: select action_information2, action_information3, action_information4,
3001: action_information5, action_information6, action_information7,
3002: action_information8, action_information9, action_information10,
3003: fnd_date.canonical_to_date(action_information11) action_information11,
3004: fnd_number.canonical_to_number(action_information12) action_information12,
3005: fnd_date.canonical_to_date(action_information13) action_information13,
3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,

Line 3005: fnd_date.canonical_to_date(action_information13) action_information13,

3001: action_information5, action_information6, action_information7,
3002: action_information8, action_information9, action_information10,
3003: fnd_date.canonical_to_date(action_information11) action_information11,
3004: fnd_number.canonical_to_number(action_information12) action_information12,
3005: fnd_date.canonical_to_date(action_information13) action_information13,
3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,

Line 3006: fnd_date.canonical_to_date(action_information14) action_information14,

3002: action_information8, action_information9, action_information10,
3003: fnd_date.canonical_to_date(action_information11) action_information11,
3004: fnd_number.canonical_to_number(action_information12) action_information12,
3005: fnd_date.canonical_to_date(action_information13) action_information13,
3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,
3010: fnd_date.canonical_to_date(action_information18) action_information18,

Line 3008: fnd_date.canonical_to_date(action_information16) action_information16,

3004: fnd_number.canonical_to_number(action_information12) action_information12,
3005: fnd_date.canonical_to_date(action_information13) action_information13,
3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,
3010: fnd_date.canonical_to_date(action_information18) action_information18,
3011: fnd_date.canonical_to_date(action_information19) action_information19,
3012: fnd_date.canonical_to_date(action_information20) action_information20,

Line 3010: fnd_date.canonical_to_date(action_information18) action_information18,

3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,
3010: fnd_date.canonical_to_date(action_information18) action_information18,
3011: fnd_date.canonical_to_date(action_information19) action_information19,
3012: fnd_date.canonical_to_date(action_information20) action_information20,
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,

Line 3011: fnd_date.canonical_to_date(action_information19) action_information19,

3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,
3010: fnd_date.canonical_to_date(action_information18) action_information18,
3011: fnd_date.canonical_to_date(action_information19) action_information19,
3012: fnd_date.canonical_to_date(action_information20) action_information20,
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,
3015: action_information23

Line 3012: fnd_date.canonical_to_date(action_information20) action_information20,

3008: fnd_date.canonical_to_date(action_information16) action_information16,
3009: action_information17,
3010: fnd_date.canonical_to_date(action_information18) action_information18,
3011: fnd_date.canonical_to_date(action_information19) action_information19,
3012: fnd_date.canonical_to_date(action_information20) action_information20,
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,
3015: action_information23
3016: from pay_payroll_actions paa,

Line 3014: fnd_date.canonical_to_date(action_information22) action_information22,

3010: fnd_date.canonical_to_date(action_information18) action_information18,
3011: fnd_date.canonical_to_date(action_information19) action_information19,
3012: fnd_date.canonical_to_date(action_information20) action_information20,
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,
3015: action_information23
3016: from pay_payroll_actions paa,
3017: pay_assignment_actions assg,
3018: pay_action_information pai