DBA Data[Home] [Help]

APPS.HR_SE_UTILITY dependencies on FND_DATE

Line 438: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information4) AND

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;

Line 439: nvl(fnd_date.canonical_to_date(hoi2.org_information5),to_date('31/12/4712','DD/MM/YYYY')) ;

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: