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;