434: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
435: AND hoi1.org_information_context = 'CLASS'
436: AND o1.organization_id = hoi2.organization_id
437: AND hoi2.ORG_INFORMATION_CONTEXT ='SE_COMPANY_MILEAGE_RATES'
438: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information4) AND
439: nvl(fnd_date.canonical_to_date(hoi2.org_information5),to_date('31/12/4712','DD/MM/YYYY')) ;
440:
441: l_rec c_get_details%ROWTYPE;
442: l_return NUMBER;
435: AND hoi1.org_information_context = 'CLASS'
436: AND o1.organization_id = hoi2.organization_id
437: AND hoi2.ORG_INFORMATION_CONTEXT ='SE_COMPANY_MILEAGE_RATES'
438: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information4) AND
439: nvl(fnd_date.canonical_to_date(hoi2.org_information5),to_date('31/12/4712','DD/MM/YYYY')) ;
440:
441: l_rec c_get_details%ROWTYPE;
442: l_return NUMBER;
443: