APPS.PAY_DK_SICKPAY_PKG dependencies on HR_ORGANIZATION_INFORMATION
Line 314: FROM hr_organization_information
310:
311: /* Modified cursor */
312: CURSOR csr_get_sickpay_defaults(p_effective_date DATE, p_org_id NUMBER) is
313: SELECT org_information1 314: FROM hr_organization_information 315: WHERE organization_id = p_org_id
316: and org_information_context = 'DK_SICKPAY_DEFAULTS'
317: AND p_effective_date BETWEEN fnd_date.canonical_to_date( org_information2) and fnd_date.canonical_to_date( org_information3)
318: order by org_information2;