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 741: select fnd_date.canonical_to_date(segment24)

737: /* Cursor to get the Position Code for the passed soft coding keyflex id */
738: cursor csr_get_latest_st_date_scl (
739: p_soft_coding_keyflex_id number
740: ) is
741: select fnd_date.canonical_to_date(segment24)
742: /* fnd_date.canonical_to_date(nvl(segment24,'0001/01/01'))*/
743: from hr_soft_coding_keyflex
744: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
745:

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

738: cursor csr_get_latest_st_date_scl (
739: p_soft_coding_keyflex_id number
740: ) is
741: select fnd_date.canonical_to_date(segment24)
742: /* fnd_date.canonical_to_date(nvl(segment24,'0001/01/01'))*/
743: from hr_soft_coding_keyflex
744: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
745:
746: l_new_latest_start_date date ;

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

786: c_input_val_name varchar2,
787: c_assignment_id number,
788: c_eff_date date
789: ) is
790: select fnd_date.canonical_to_date (peev.screen_entry_value)
791: from pay_element_types_f pet,
792: pay_input_values_f piv,
793: pay_element_entries_f peef,
794: pay_element_entry_values_f peev

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

1261: l_prev_hour_eff_date := null;
1262: l_lu_change_flag := 'N';
1263: l_local_unit_org_no := i.local_unit_org_no ;
1264: l_retrospective_hire_flag := 'N';
1265: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');
1266: l_new_latest_start_date := null;
1267: --
1268: --
1269: /* Get the Start Date */

Line 1366: p_action_information14 => fnd_date.date_to_canonical(

1362: p_action_information7 => j.person_id,
1363: p_action_information8 => j.national_identifier,
1364: p_action_information9 => j.full_name,
1365: p_action_information10 => j.employee_number,
1366: p_action_information14 => fnd_date.date_to_canonical(
1367: collemptable (4).temination_date),
1368: p_action_information21 => collemptable (4).status_type,
1369: p_assignment_id => j.assignment_id
1370: );

Line 1518: p_action_information11 => fnd_date.date_to_canonical(

1514: p_action_information7 => j.person_id,
1515: p_action_information8 => j.national_identifier,
1516: p_action_information9 => j.full_name,
1517: p_action_information10 => j.employee_number,
1518: p_action_information11 => fnd_date.date_to_canonical(
1519: collemptable (1).start_date),
1520: p_action_information12 => fnd_number.number_to_canonical(
1521: collemptable (1).working_hours),
1522: p_action_information17 => collemptable (1).job_id,

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

1806: p_action_information9 => j.full_name -- Full Name
1807: ,
1808: p_action_information10 => j.employee_number -- Employee Number
1809: ,
1810: p_action_information11 => fnd_date.date_to_canonical(collemptable (
1811: cnt
1812: ).start_date) -- Employment Start Date
1813: --,p_action_information16 => p_time_period_id
1814: ,

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

1815: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
1816: cnt
1817: ).working_hours) -- Weekly Working Hours
1818: ,
1819: p_action_information13 => fnd_date.date_to_canonical(collemptable (
1820: cnt
1821: ).hour_date_change) -- Date of change of hours
1822: ,
1823: p_action_information14 => fnd_date.date_to_canonical(collemptable (

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

1819: p_action_information13 => fnd_date.date_to_canonical(collemptable (
1820: cnt
1821: ).hour_date_change) -- Date of change of hours
1822: ,
1823: p_action_information14 => fnd_date.date_to_canonical(collemptable (
1824: cnt
1825: ).temination_date) -- Employment Termination Date
1826: ,
1827: p_action_information15 => collemptable (

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

1827: p_action_information15 => collemptable (
1828: cnt
1829: ).lu_value -- Local Unit Org No
1830: ,
1831: p_action_information16 => fnd_date.date_to_canonical(collemptable (
1832: cnt
1833: ).lu_change_date) -- Local Unit Change Date
1834: ,
1835: p_action_information17 => collemptable (

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

1835: p_action_information17 => collemptable (
1836: cnt
1837: ).job_id -- Occupation
1838: ,
1839: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
1840: cnt
1841: ).job_change_date) -- Occupation change date
1842: ,
1843: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

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

1839: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
1840: cnt
1841: ).job_change_date) -- Occupation change date
1842: ,
1843: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
1844: ,
1845: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1846: p_action_information21 => collemptable (
1847: cnt

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

1841: ).job_change_date) -- Occupation change date
1842: ,
1843: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
1844: ,
1845: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1846: p_action_information21 => collemptable (
1847: cnt
1848: ).status_type,
1849: p_action_information22 => fnd_date.date_to_canonical(collemptable (

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

1845: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
1846: p_action_information21 => collemptable (
1847: cnt
1848: ).status_type,
1849: p_action_information22 => fnd_date.date_to_canonical(collemptable (
1850: cnt
1851: ).corrected_start_date),
1852: p_action_information23 => collemptable (cnt).rev_temination,
1853: p_assignment_id => j.assignment_id

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

2138: l_retrospective_hire_flag := 'Y' ;
2139: l_retrospective_date := l_detailed_output(cnt).effective_date;
2140:
2141: else
2142: l_retrospective_date := fnd_date.canonical_to_date('0001/01/01');
2143: end if;
2144:
2145: else
2146: if l_Emp_start_Date <> l_detailed_output (cnt).effective_date then

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

2875: p_action_information9 => j.full_name -- Full Name
2876: ,
2877: p_action_information10 => j.employee_number -- Employee Number
2878: ,
2879: p_action_information11 => fnd_date.date_to_canonical(collemptable (
2880: cnt
2881: ).start_date) -- Employment Start Date
2882: --,p_action_information16 => p_time_period_id
2883: ,

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

2884: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
2885: cnt
2886: ).working_hours) -- Weekly Working Hours
2887: ,
2888: p_action_information13 => fnd_date.date_to_canonical(collemptable (
2889: cnt
2890: ).hour_date_change) -- Date of change of hours
2891: ,
2892: p_action_information14 => fnd_date.date_to_canonical(collemptable (

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

2888: p_action_information13 => fnd_date.date_to_canonical(collemptable (
2889: cnt
2890: ).hour_date_change) -- Date of change of hours
2891: ,
2892: p_action_information14 => fnd_date.date_to_canonical(collemptable (
2893: cnt
2894: ).temination_date) -- Employment Termination Date
2895: ,
2896: p_action_information15 => collemptable (

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

2896: p_action_information15 => collemptable (
2897: cnt
2898: ).lu_value -- Local Unit Org No
2899: ,
2900: p_action_information16 => fnd_date.date_to_canonical(collemptable (
2901: cnt
2902: ).lu_change_date) -- Local Unit Change Date
2903: ,
2904: p_action_information17 => collemptable (

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

2904: p_action_information17 => collemptable (
2905: cnt
2906: ).job_id -- Occupation
2907: ,
2908: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
2909: cnt
2910: ).job_change_date) -- Occupation change date
2911: ,
2912: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date

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

2908: p_action_information18 =>fnd_date.date_to_canonical( collemptable (
2909: cnt
2910: ).job_change_date) -- Occupation change date
2911: ,
2912: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
2913: ,
2914: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2915: p_action_information21 => collemptable (
2916: cnt

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

2910: ).job_change_date) -- Occupation change date
2911: ,
2912: p_action_information19 => fnd_date.date_to_canonical(l_abs_start_date) -- Occupation change date
2913: ,
2914: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2915: p_action_information21 => collemptable (
2916: cnt
2917: ).status_type,
2918: p_action_information22 => fnd_date.date_to_canonical(collemptable (

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

2914: p_action_information20 => fnd_date.date_to_canonical(l_abs_end_date),
2915: p_action_information21 => collemptable (
2916: cnt
2917: ).status_type,
2918: p_action_information22 => fnd_date.date_to_canonical(collemptable (
2919: cnt
2920: ).corrected_start_date),
2921: p_action_information23 => collemptable (cnt).rev_temination,
2922: p_assignment_id => j.assignment_id

Line 3190: fnd_date.canonical_to_date(action_information11) action_information11,

3186: ) is
3187: select action_information2, action_information3, action_information4,
3188: action_information5, action_information6, action_information7,
3189: action_information8, action_information9, action_information10,
3190: fnd_date.canonical_to_date(action_information11) action_information11,
3191: fnd_number.canonical_to_number(action_information12) action_information12,
3192: fnd_date.canonical_to_date(action_information13) action_information13,
3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,

Line 3192: fnd_date.canonical_to_date(action_information13) action_information13,

3188: action_information5, action_information6, action_information7,
3189: action_information8, action_information9, action_information10,
3190: fnd_date.canonical_to_date(action_information11) action_information11,
3191: fnd_number.canonical_to_number(action_information12) action_information12,
3192: fnd_date.canonical_to_date(action_information13) action_information13,
3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,

Line 3193: fnd_date.canonical_to_date(action_information14) action_information14,

3189: action_information8, action_information9, action_information10,
3190: fnd_date.canonical_to_date(action_information11) action_information11,
3191: fnd_number.canonical_to_number(action_information12) action_information12,
3192: fnd_date.canonical_to_date(action_information13) action_information13,
3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,
3197: fnd_date.canonical_to_date(action_information18) action_information18,

Line 3195: fnd_date.canonical_to_date(action_information16) action_information16,

3191: fnd_number.canonical_to_number(action_information12) action_information12,
3192: fnd_date.canonical_to_date(action_information13) action_information13,
3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,
3197: fnd_date.canonical_to_date(action_information18) action_information18,
3198: fnd_date.canonical_to_date(action_information19) action_information19,
3199: fnd_date.canonical_to_date(action_information20) action_information20,

Line 3197: fnd_date.canonical_to_date(action_information18) action_information18,

3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,
3197: fnd_date.canonical_to_date(action_information18) action_information18,
3198: fnd_date.canonical_to_date(action_information19) action_information19,
3199: fnd_date.canonical_to_date(action_information20) action_information20,
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,

Line 3198: fnd_date.canonical_to_date(action_information19) action_information19,

3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,
3197: fnd_date.canonical_to_date(action_information18) action_information18,
3198: fnd_date.canonical_to_date(action_information19) action_information19,
3199: fnd_date.canonical_to_date(action_information20) action_information20,
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23

Line 3199: fnd_date.canonical_to_date(action_information20) action_information20,

3195: fnd_date.canonical_to_date(action_information16) action_information16,
3196: action_information17,
3197: fnd_date.canonical_to_date(action_information18) action_information18,
3198: fnd_date.canonical_to_date(action_information19) action_information19,
3199: fnd_date.canonical_to_date(action_information20) action_information20,
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23
3203: from pay_payroll_actions paa,

Line 3201: fnd_date.canonical_to_date(action_information22) action_information22,

3197: fnd_date.canonical_to_date(action_information18) action_information18,
3198: fnd_date.canonical_to_date(action_information19) action_information19,
3199: fnd_date.canonical_to_date(action_information20) action_information20,
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23
3203: from pay_payroll_actions paa,
3204: pay_assignment_actions assg,
3205: pay_action_information pai