DBA Data[Home] [Help]

APPS.PAY_DK_SICKPAY_PKG dependencies on FND_DATE

Line 319: AND p_effective_date BETWEEN fnd_date.canonical_to_date( org_information2) and fnd_date.canonical_to_date( org_information3)

315: SELECT org_information1
316: FROM hr_organization_information
317: WHERE organization_id = p_org_id
318: and org_information_context = 'DK_SICKPAY_DEFAULTS'
319: AND p_effective_date BETWEEN fnd_date.canonical_to_date( org_information2) and fnd_date.canonical_to_date( org_information3)
320: order by org_information2;
321: TYPE l_record is record (sec_27 varchar2(1));
322: l_rec l_record;
323: TYPE l_table is table of l_record index by BINARY_INTEGER;