APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on FND_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 2151: p_action_information11 => fnd_date.date_to_canonical (

2147: p_action_information9 => j.full_name -- Full Name
2148: ,
2149: p_action_information10 => j.employee_number -- Employee Number
2150: ,
2151: p_action_information11 => fnd_date.date_to_canonical (
2152: l_emp_start_date
2153: ) -- Employment Start Date
2154: --,p_action_information16 => p_time_period_id
2155: ,

Line 2158: p_action_information13 => fnd_date.date_to_canonical (

2154: --,p_action_information16 => p_time_period_id
2155: ,
2156: p_action_information12 => fnd_number.number_to_canonical(l_hour_value) -- Weekly Working Hours
2157: ,
2158: p_action_information13 => fnd_date.date_to_canonical (
2159: l_hour_change_effective_date
2160: ) -- Date of change of hours
2161: ,
2162: p_action_information14 => fnd_date.date_to_canonical (

Line 2162: p_action_information14 => fnd_date.date_to_canonical (

2158: p_action_information13 => fnd_date.date_to_canonical (
2159: l_hour_change_effective_date
2160: ) -- Date of change of hours
2161: ,
2162: p_action_information14 => fnd_date.date_to_canonical (
2163: l_emp_end_date
2164: ) -- Employment Termination Date
2165: ,
2166: p_action_information15 => l_lu_org_no -- Local Unit Org No

Line 2168: p_action_information16 => fnd_date.date_to_canonical (

2164: ) -- Employment Termination Date
2165: ,
2166: p_action_information15 => l_lu_org_no -- Local Unit Org No
2167: ,
2168: p_action_information16 => fnd_date.date_to_canonical (
2169: l_lu_change_effective_date
2170: ) -- Local Unit Change Date
2171: ,
2172: p_action_information17 => j.position_code -- Occupation

Line 2174: p_action_information18 => fnd_date.date_to_canonical (

2170: ) -- Local Unit Change Date
2171: ,
2172: p_action_information17 => j.position_code -- Occupation
2173: ,
2174: p_action_information18 => fnd_date.date_to_canonical (
2175: l_job_change_effective_date
2176: ) -- Occupation change date
2177: ,
2178: p_action_information19 => fnd_date.date_to_canonical (

Line 2178: p_action_information19 => fnd_date.date_to_canonical (

2174: p_action_information18 => fnd_date.date_to_canonical (
2175: l_job_change_effective_date
2176: ) -- Occupation change date
2177: ,
2178: p_action_information19 => fnd_date.date_to_canonical (
2179: l_abs_start_date
2180: ) -- Occupation change date
2181: ,
2182: p_action_information20 => fnd_date.date_to_canonical (

Line 2182: p_action_information20 => fnd_date.date_to_canonical (

2178: p_action_information19 => fnd_date.date_to_canonical (
2179: l_abs_start_date
2180: ) -- Occupation change date
2181: ,
2182: p_action_information20 => fnd_date.date_to_canonical (
2183: l_abs_end_date
2184: ),
2185: p_assignment_id => j.assignment_id
2186: );

Line 2320: fnd_date.canonical_to_date (action_information11)

2316: ) is
2317: select action_information2, action_information3, action_information4,
2318: action_information5, action_information6, action_information7,
2319: action_information8, action_information9, action_information10,
2320: fnd_date.canonical_to_date (action_information11)
2321: action_information11,
2322: action_information12,
2323: fnd_date.canonical_to_date (action_information13)
2324: action_information13,

Line 2323: fnd_date.canonical_to_date (action_information13)

2319: action_information8, action_information9, action_information10,
2320: fnd_date.canonical_to_date (action_information11)
2321: action_information11,
2322: action_information12,
2323: fnd_date.canonical_to_date (action_information13)
2324: action_information13,
2325: fnd_date.canonical_to_date (action_information14)
2326: action_information14,
2327: action_information15,

Line 2325: fnd_date.canonical_to_date (action_information14)

2321: action_information11,
2322: action_information12,
2323: fnd_date.canonical_to_date (action_information13)
2324: action_information13,
2325: fnd_date.canonical_to_date (action_information14)
2326: action_information14,
2327: action_information15,
2328: fnd_date.canonical_to_date (action_information16)
2329: action_information16,

Line 2328: fnd_date.canonical_to_date (action_information16)

2324: action_information13,
2325: fnd_date.canonical_to_date (action_information14)
2326: action_information14,
2327: action_information15,
2328: fnd_date.canonical_to_date (action_information16)
2329: action_information16,
2330: action_information17,
2331: fnd_date.canonical_to_date (action_information18)
2332: action_information18,

Line 2331: fnd_date.canonical_to_date (action_information18)

2327: action_information15,
2328: fnd_date.canonical_to_date (action_information16)
2329: action_information16,
2330: action_information17,
2331: fnd_date.canonical_to_date (action_information18)
2332: action_information18,
2333: fnd_date.canonical_to_date (action_information19)
2334: action_information19,
2335: fnd_date.canonical_to_date (action_information20)

Line 2333: fnd_date.canonical_to_date (action_information19)

2329: action_information16,
2330: action_information17,
2331: fnd_date.canonical_to_date (action_information18)
2332: action_information18,
2333: fnd_date.canonical_to_date (action_information19)
2334: action_information19,
2335: fnd_date.canonical_to_date (action_information20)
2336: action_information20
2337: from pay_payroll_actions paa,

Line 2335: fnd_date.canonical_to_date (action_information20)

2331: fnd_date.canonical_to_date (action_information18)
2332: action_information18,
2333: fnd_date.canonical_to_date (action_information19)
2334: action_information19,
2335: fnd_date.canonical_to_date (action_information20)
2336: action_information20
2337: from pay_payroll_actions paa,
2338: pay_assignment_actions assg,
2339: pay_action_information pai