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_STATSR_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 314: , HR_ORGANIZATION_INFORMATION hoi1

310: -- ,loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3 ADDR
311: ,SUBSTR (loc.ADDRESS_LINE_1,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_2,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_3,1,80) ADDR --Bug Fix-4998649
312: ,loc.postal_code PCODE
313: FROM HR_ORGANIZATION_UNITS hou1
314: , HR_ORGANIZATION_INFORMATION hoi1
315: , HR_ORGANIZATION_INFORMATION hoi2
316: , HR_LOCATIONS loc
317: WHERE hou1.business_group_id = p_business_group_id
318: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)

Line 315: , HR_ORGANIZATION_INFORMATION hoi2

311: ,SUBSTR (loc.ADDRESS_LINE_1,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_2,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_3,1,80) ADDR --Bug Fix-4998649
312: ,loc.postal_code PCODE
313: FROM HR_ORGANIZATION_UNITS hou1
314: , HR_ORGANIZATION_INFORMATION hoi1
315: , HR_ORGANIZATION_INFORMATION hoi2
316: , HR_LOCATIONS loc
317: WHERE hou1.business_group_id = p_business_group_id
318: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)
319: and hou1.location_id = loc.LOCATION_ID(+)

Line 340: , HR_ORGANIZATION_INFORMATION hoi1

336: -- ,loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3 ADDR
337: ,SUBSTR (loc.ADDRESS_LINE_1,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_2,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_3,1,80) ADDR --Bug Fix-4998649
338: ,loc.postal_code PCODE
339: FROM HR_ORGANIZATION_UNITS hou
340: , HR_ORGANIZATION_INFORMATION hoi1
341: , HR_ORGANIZATION_INFORMATION hoi2
342: , HR_LOCATIONS loc
343: WHERE hou.business_group_id = p_business_group_id
344: and hoi1.organization_id = hou.organization_id

Line 341: , HR_ORGANIZATION_INFORMATION hoi2

337: ,SUBSTR (loc.ADDRESS_LINE_1,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_2,1,80)||' '||SUBSTR (loc.ADDRESS_LINE_3,1,80) ADDR --Bug Fix-4998649
338: ,loc.postal_code PCODE
339: FROM HR_ORGANIZATION_UNITS hou
340: , HR_ORGANIZATION_INFORMATION hoi1
341: , HR_ORGANIZATION_INFORMATION hoi2
342: , HR_LOCATIONS loc
343: WHERE hou.business_group_id = p_business_group_id
344: and hoi1.organization_id = hou.organization_id
345: and hou.location_id = loc.LOCATION_ID(+)

Line 360: , HR_ORGANIZATION_INFORMATION hoi1

356: /* Modified check on context for bug fix 4997786 */
357: CURSOR csr_get_le_da_off_codes(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
358: SELECT hoi2.ORG_INFORMATION1 DA_SCODE
359: FROM HR_ORGANIZATION_UNITS hou
360: , HR_ORGANIZATION_INFORMATION hoi1
361: , HR_ORGANIZATION_INFORMATION hoi2
362: WHERE hou.business_group_id = p_business_group_id
363: and hoi1.organization_id = hou.organization_id
364: and hoi1.organization_id = p_le_id

Line 361: , HR_ORGANIZATION_INFORMATION hoi2

357: CURSOR csr_get_le_da_off_codes(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
358: SELECT hoi2.ORG_INFORMATION1 DA_SCODE
359: FROM HR_ORGANIZATION_UNITS hou
360: , HR_ORGANIZATION_INFORMATION hoi1
361: , HR_ORGANIZATION_INFORMATION hoi2
362: WHERE hou.business_group_id = p_business_group_id
363: and hoi1.organization_id = hou.organization_id
364: and hoi1.organization_id = p_le_id
365: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 378: , HR_ORGANIZATION_INFORMATION hoi1

374: /* Cursor to fetch the Business Group Details */
375: CURSOR csr_get_bg_details(p_business_group_id NUMBER, p_effective_date DATE) IS
376: SELECT hoi2.ORG_INFORMATION1 DA_SYS_NO
377: FROM HR_ORGANIZATION_UNITS hou
378: , HR_ORGANIZATION_INFORMATION hoi1
379: , HR_ORGANIZATION_INFORMATION hoi2
380: WHERE hou.business_group_id = p_business_group_id
381: and hoi1.organization_id = hou.organization_id
382: and hoi1.organization_id = p_business_group_id

Line 379: , HR_ORGANIZATION_INFORMATION hoi2

375: CURSOR csr_get_bg_details(p_business_group_id NUMBER, p_effective_date DATE) IS
376: SELECT hoi2.ORG_INFORMATION1 DA_SYS_NO
377: FROM HR_ORGANIZATION_UNITS hou
378: , HR_ORGANIZATION_INFORMATION hoi1
379: , HR_ORGANIZATION_INFORMATION hoi2
380: WHERE hou.business_group_id = p_business_group_id
381: and hoi1.organization_id = hou.organization_id
382: and hoi1.organization_id = p_business_group_id
383: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 642: , HR_ORGANIZATION_INFORMATION hoi1

638: ,hoi2.ORG_INFORMATION2 EMP_GRP
639: ,hoi2.ORG_INFORMATION3 WORK_HOURS
640: ,hoi2.ORG_INFORMATION4 FREQ
641: FROM HR_ORGANIZATION_UNITS hou
642: , HR_ORGANIZATION_INFORMATION hoi1
643: , HR_ORGANIZATION_INFORMATION hoi2
644: WHERE hou.business_group_id = p_business_group_id
645: and hoi1.organization_id = hou.organization_id
646: and hoi1.organization_id = p_le_id

Line 643: , HR_ORGANIZATION_INFORMATION hoi2

639: ,hoi2.ORG_INFORMATION3 WORK_HOURS
640: ,hoi2.ORG_INFORMATION4 FREQ
641: FROM HR_ORGANIZATION_UNITS hou
642: , HR_ORGANIZATION_INFORMATION hoi1
643: , HR_ORGANIZATION_INFORMATION hoi2
644: WHERE hou.business_group_id = p_business_group_id
645: and hoi1.organization_id = hou.organization_id
646: and hoi1.organization_id = p_le_id
647: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 661: , HR_ORGANIZATION_INFORMATION hoi1

657: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
658: ,hoi2.ORG_INFORMATION3 HOURLY_ACCR_RATE
659: ,hoi2.ORG_INFORMATION4 SAL_ALLOW_RATE
660: FROM HR_ORGANIZATION_UNITS hou
661: , HR_ORGANIZATION_INFORMATION hoi1
662: , HR_ORGANIZATION_INFORMATION hoi2
663: WHERE hou.business_group_id = p_business_group_id
664: and hoi1.organization_id = hou.organization_id
665: and hoi1.organization_id = p_le_id

Line 662: , HR_ORGANIZATION_INFORMATION hoi2

658: ,hoi2.ORG_INFORMATION3 HOURLY_ACCR_RATE
659: ,hoi2.ORG_INFORMATION4 SAL_ALLOW_RATE
660: FROM HR_ORGANIZATION_UNITS hou
661: , HR_ORGANIZATION_INFORMATION hoi1
662: , HR_ORGANIZATION_INFORMATION hoi2
663: WHERE hou.business_group_id = p_business_group_id
664: and hoi1.organization_id = hou.organization_id
665: and hoi1.organization_id = p_le_id
666: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 674: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)

670: and hoi2.organization_id = hoi1.organization_id
671: and p_effective_date BETWEEN hou.DATE_FROM and nvl(hou.DATE_TO, p_effective_date);
672:
673: /* Cursor to fetch the HR Org level Production Unit Code*/
674: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
675: IS
676: SELECT hoi2.ORG_INFORMATION6
677: FROM hr_organization_information hoi1
678: , hr_organization_information hoi2

Line 677: FROM hr_organization_information hoi1

673: /* Cursor to fetch the HR Org level Production Unit Code*/
674: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
675: IS
676: SELECT hoi2.ORG_INFORMATION6
677: FROM hr_organization_information hoi1
678: , hr_organization_information hoi2
679: WHERE hoi1.organization_id = hoi2.organization_id
680: AND hoi1.organization_id = hr_org_id
681: AND hoi1.org_information1 = 'HR_ORG'

Line 678: , hr_organization_information hoi2

674: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
675: IS
676: SELECT hoi2.ORG_INFORMATION6
677: FROM hr_organization_information hoi1
678: , hr_organization_information hoi2
679: WHERE hoi1.organization_id = hoi2.organization_id
680: AND hoi1.organization_id = hr_org_id
681: AND hoi1.org_information1 = 'HR_ORG'
682: AND hoi1.org_information_context = 'CLASS'