APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on FND_DATE

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

610: c_input_val_name varchar2,
611: c_assignment_id number,
612: c_eff_date date
613: ) is
614: select fnd_date.canonical_to_date (peev.screen_entry_value)
615: from pay_element_types_f pet,
616: pay_input_values_f piv,
617: pay_element_entries_f peef,
618: pay_element_entry_values_f peev

Line 1974: p_action_information11 => fnd_date.date_to_canonical (

1970: p_action_information9 => j.full_name -- Full Name
1971: ,
1972: p_action_information10 => j.employee_number -- Employee Number
1973: ,
1974: p_action_information11 => fnd_date.date_to_canonical (
1975: l_emp_start_date
1976: ) -- Employment Start Date
1977: --,p_action_information16 => p_time_period_id
1978: ,

Line 1981: p_action_information13 => fnd_date.date_to_canonical (

1977: --,p_action_information16 => p_time_period_id
1978: ,
1979: p_action_information12 => fnd_number.number_to_canonical(l_hour_value) -- Weekly Working Hours
1980: ,
1981: p_action_information13 => fnd_date.date_to_canonical (
1982: l_hour_change_effective_date
1983: ) -- Date of change of hours
1984: ,
1985: p_action_information14 => fnd_date.date_to_canonical (

Line 1985: p_action_information14 => fnd_date.date_to_canonical (

1981: p_action_information13 => fnd_date.date_to_canonical (
1982: l_hour_change_effective_date
1983: ) -- Date of change of hours
1984: ,
1985: p_action_information14 => fnd_date.date_to_canonical (
1986: l_emp_end_date
1987: ) -- Employment Termination Date
1988: ,
1989: p_action_information15 => l_lu_org_no -- Local Unit Org No

Line 1991: p_action_information16 => fnd_date.date_to_canonical (

1987: ) -- Employment Termination Date
1988: ,
1989: p_action_information15 => l_lu_org_no -- Local Unit Org No
1990: ,
1991: p_action_information16 => fnd_date.date_to_canonical (
1992: l_lu_change_effective_date
1993: ) -- Local Unit Change Date
1994: ,
1995: p_action_information17 => j.position_code -- Occupation

Line 1997: p_action_information18 => fnd_date.date_to_canonical (

1993: ) -- Local Unit Change Date
1994: ,
1995: p_action_information17 => j.position_code -- Occupation
1996: ,
1997: p_action_information18 => fnd_date.date_to_canonical (
1998: l_job_change_effective_date
1999: ) -- Occupation change date
2000: ,
2001: p_action_information19 => fnd_date.date_to_canonical (

Line 2001: p_action_information19 => fnd_date.date_to_canonical (

1997: p_action_information18 => fnd_date.date_to_canonical (
1998: l_job_change_effective_date
1999: ) -- Occupation change date
2000: ,
2001: p_action_information19 => fnd_date.date_to_canonical (
2002: l_abs_start_date
2003: ) -- Occupation change date
2004: ,
2005: p_action_information20 => fnd_date.date_to_canonical (

Line 2005: p_action_information20 => fnd_date.date_to_canonical (

2001: p_action_information19 => fnd_date.date_to_canonical (
2002: l_abs_start_date
2003: ) -- Occupation change date
2004: ,
2005: p_action_information20 => fnd_date.date_to_canonical (
2006: l_abs_end_date
2007: ),
2008: p_assignment_id => j.assignment_id
2009: );

Line 2143: fnd_date.canonical_to_date (action_information11)

2139: ) is
2140: select action_information2, action_information3, action_information4,
2141: action_information5, action_information6, action_information7,
2142: action_information8, action_information9, action_information10,
2143: fnd_date.canonical_to_date (action_information11)
2144: action_information11,
2145: action_information12,
2146: fnd_date.canonical_to_date (action_information13)
2147: action_information13,

Line 2146: fnd_date.canonical_to_date (action_information13)

2142: action_information8, action_information9, action_information10,
2143: fnd_date.canonical_to_date (action_information11)
2144: action_information11,
2145: action_information12,
2146: fnd_date.canonical_to_date (action_information13)
2147: action_information13,
2148: fnd_date.canonical_to_date (action_information14)
2149: action_information14,
2150: action_information15,

Line 2148: fnd_date.canonical_to_date (action_information14)

2144: action_information11,
2145: action_information12,
2146: fnd_date.canonical_to_date (action_information13)
2147: action_information13,
2148: fnd_date.canonical_to_date (action_information14)
2149: action_information14,
2150: action_information15,
2151: fnd_date.canonical_to_date (action_information16)
2152: action_information16,

Line 2151: fnd_date.canonical_to_date (action_information16)

2147: action_information13,
2148: fnd_date.canonical_to_date (action_information14)
2149: action_information14,
2150: action_information15,
2151: fnd_date.canonical_to_date (action_information16)
2152: action_information16,
2153: action_information17,
2154: fnd_date.canonical_to_date (action_information18)
2155: action_information18,

Line 2154: fnd_date.canonical_to_date (action_information18)

2150: action_information15,
2151: fnd_date.canonical_to_date (action_information16)
2152: action_information16,
2153: action_information17,
2154: fnd_date.canonical_to_date (action_information18)
2155: action_information18,
2156: fnd_date.canonical_to_date (action_information19)
2157: action_information19,
2158: fnd_date.canonical_to_date (action_information20)

Line 2156: fnd_date.canonical_to_date (action_information19)

2152: action_information16,
2153: action_information17,
2154: fnd_date.canonical_to_date (action_information18)
2155: action_information18,
2156: fnd_date.canonical_to_date (action_information19)
2157: action_information19,
2158: fnd_date.canonical_to_date (action_information20)
2159: action_information20
2160: from pay_payroll_actions paa,

Line 2158: fnd_date.canonical_to_date (action_information20)

2154: fnd_date.canonical_to_date (action_information18)
2155: action_information18,
2156: fnd_date.canonical_to_date (action_information19)
2157: action_information19,
2158: fnd_date.canonical_to_date (action_information20)
2159: action_information20
2160: from pay_payroll_actions paa,
2161: pay_assignment_actions assg,
2162: pay_action_information pai