82: (
83: p_assignment_id number
84: ,p_upload_date date
85: ) is
86: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
87: 12*(floor(months_between(p_upload_date,
88: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
89: END_OF_TIME)
90: from per_assignments_f ASS
84: ,p_upload_date date
85: ) is
86: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
87: 12*(floor(months_between(p_upload_date,
88: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
89: END_OF_TIME)
90: from per_assignments_f ASS
91: ,hr_organization_information HOI
92: where ASS.assignment_id = p_assignment_id
101: (
102: p_assignment_id number
103: ,p_upload_date date
104: ) is
105: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
106: 3*(floor(months_between(p_upload_date,
107: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
108: END_OF_TIME)
109: from per_assignments_f ASS
103: ,p_upload_date date
104: ) is
105: select nvl(add_months(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11),
106: 3*(floor(months_between(p_upload_date,
107: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
108: END_OF_TIME)
109: from per_assignments_f ASS
110: ,hr_organization_information HOI
111: where ASS.assignment_id = p_assignment_id