70: (
71: p_assignment_id number
72: ,p_upload_date date
73: ) is
74: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
75: 12*(floor(months_between(p_upload_date,
76: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
77: END_OF_TIME)
78: from per_assignments_f ASS
72: ,p_upload_date date
73: ) is
74: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
75: 12*(floor(months_between(p_upload_date,
76: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
77: END_OF_TIME)
78: from per_assignments_f ASS
79: ,hr_organization_information HOI
80: where ASS.assignment_id = p_assignment_id
105: (
106: p_assignment_id number
107: ,p_upload_date date
108: ) is
109: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
110: 3*(floor(months_between(p_upload_date,
111: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
112: END_OF_TIME)
113: from per_assignments_f ASS
107: ,p_upload_date date
108: ) is
109: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
110: 3*(floor(months_between(p_upload_date,
111: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
112: END_OF_TIME)
113: from per_assignments_f ASS
114: ,hr_organization_information HOI
115: where ASS.assignment_id = p_assignment_id