eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_SICKNESS_DP201 dependencies on HR_ORGANIZATION_INFORMATION

Line 152: hr_organization_information hoi1

148: hoi1.org_information4
149: ,hoi1.org_information3
150: ,hoi2.org_information1
151: FROM
152: hr_organization_information hoi1
153: ,hr_organization_information hoi2
154: WHERE
155: hoi1.organization_id = p_leg_emp_id
156: AND hoi2.organization_id = hoi1.organization_id

Line 153: ,hr_organization_information hoi2

149: ,hoi1.org_information3
150: ,hoi2.org_information1
151: FROM
152: hr_organization_information hoi1
153: ,hr_organization_information hoi2
154: WHERE
155: hoi1.organization_id = p_leg_emp_id
156: AND hoi2.organization_id = hoi1.organization_id
157: AND hoi1.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'

Line 317: hr_organization_information hoi

313: CURSOR csr_le_cvr(p_le_id NUMBER) IS
314: SELECT
315: hoi.org_information1 le_cvr_num
316: FROM
317: hr_organization_information hoi
318: WHERE
319: hoi.organization_id = p_le_id
320: AND hoi.org_information_context = 'DK_LEGAL_ENTITY_DETAILS';
321:

Line 354: hr_organization_information hoi

350: CURSOR csr_section27(p_effective_date DATE, p_le_id NUMBER) IS
351: SELECT
352: hoi.org_information1
353: FROM
354: hr_organization_information hoi
355: WHERE
356: hoi.organization_id = p_le_id
357: AND hoi.org_information_context = 'DK_SICKPAY_DEFAULTS'
358: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2) and fnd_date.canonical_to_date(hoi.org_information3)

Line 365: hr_organization_information

361: CURSOR csr_le_work_pattern(p_org_id NUMBER) is
362: SELECT
363: org_information1 le_work_pattern
364: FROM
365: hr_organization_information
366: WHERE
367: organization_id = p_org_id
368: AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
369:

Line 393: l_section27 hr_organization_information.org_information1%TYPE;

389: --l_period_type pay_payrolls_f.period_type%TYPE;
390: l_check VARCHAR2(1);
391: le_cvr_rec csr_le_cvr%ROWTYPE; --Bug 5049222 fix
392: l_absence_days NUMBER ;
393: l_section27 hr_organization_information.org_information1%TYPE;
394: --l_section28 VARCHAR2(10) ;
395: soft_coded_rec csr_soft_coded_details%ROWTYPE;
396: l_payroll_proc_start_date DATE ;
397: l_74hrs VARCHAR2(150);