183: p_assignment_id number
184: ,p_upload_date date
185: ) is
186: select nvl(trunc(p_upload_date -
187: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
188: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
189: END_OF_TIME)
190: from per_assignments_f ASS
191: ,hr_organization_information HOI
184: ,p_upload_date date
185: ) is
186: select nvl(trunc(p_upload_date -
187: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
188: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
189: END_OF_TIME)
190: from per_assignments_f ASS
191: ,hr_organization_information HOI
192: where ASS.assignment_id = p_assignment_id
202: p_assignment_id number
203: ,p_upload_date date
204: ) is
205: select nvl(add_months(trunc(add_months(p_upload_date, -
206: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
207: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
203: ,p_upload_date date
204: ) is
205: select nvl(add_months(trunc(add_months(p_upload_date, -
206: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
207: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
211: from per_assignments_f ASS
204: ) is
205: select nvl(add_months(trunc(add_months(p_upload_date, -
206: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
207: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
211: from per_assignments_f ASS
212: ,hr_organization_information HOI
205: select nvl(add_months(trunc(add_months(p_upload_date, -
206: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
207: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
211: from per_assignments_f ASS
212: ,hr_organization_information HOI
213: where ASS.assignment_id = p_assignment_id