DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on FND_DATE

Line 230: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);

226: select nvl(to_number(ORG_INFORMATION1),0)
227: from hr_organization_information
228: where ORGANIZATION_ID = p_org_id
229: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
230: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);
231:
232:
233:
234: ----------------------------------Function declarations----------------------------------------------