DBA Data[Home] [Help]

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;