DBA Data[Home] [Help]

APPS.HR_SE_UTILITY dependencies on FND_DATE

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

389: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
390: AND hoi1.org_information_context = 'CLASS'
391: AND o1.organization_id = hoi2.organization_id
392: AND hoi2.ORG_INFORMATION_CONTEXT ='SE_COMPANY_MILEAGE_RATES'
393: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information4) AND
394: nvl(fnd_date.canonical_to_date(hoi2.org_information5),to_date('31/12/4712','DD/MM/YYYY')) ;
395:
396: l_rec c_get_details%ROWTYPE;
397: l_return NUMBER;

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

390: AND hoi1.org_information_context = 'CLASS'
391: AND o1.organization_id = hoi2.organization_id
392: AND hoi2.ORG_INFORMATION_CONTEXT ='SE_COMPANY_MILEAGE_RATES'
393: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information4) AND
394: nvl(fnd_date.canonical_to_date(hoi2.org_information5),to_date('31/12/4712','DD/MM/YYYY')) ;
395:
396: l_rec c_get_details%ROWTYPE;
397: l_return NUMBER;
398: