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
81: and p_upload_date between ASS.effective_start_date
82: and ASS.effective_end_date
83: and HOI.organization_id = ASS.business_group_id
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
116: and p_upload_date between ASS.effective_start_date
117: and ASS.effective_end_date
118: and HOI.organization_id = ASS.business_group_id