APPS.PAY_DK_SICKPAY_PKG dependencies on HR_ORGANIZATION_INFORMATION
Line 316: FROM hr_organization_information
312:
313: /* Modified cursor */
314: CURSOR csr_get_sickpay_defaults(p_effective_date DATE, p_org_id NUMBER) is
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;