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 339: , HR_ORGANIZATION_INFORMATION hoi1

335: -- ,loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3 ADDR
336: ,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
337: ,loc.postal_code PCODE
338: FROM HR_ORGANIZATION_UNITS hou
339: , HR_ORGANIZATION_INFORMATION hoi1
340: , HR_ORGANIZATION_INFORMATION hoi2
341: , HR_LOCATIONS loc
342: WHERE hou.business_group_id = p_business_group_id
343: and hoi1.organization_id = hou.organization_id

Line 340: , HR_ORGANIZATION_INFORMATION hoi2

336: ,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
337: ,loc.postal_code PCODE
338: FROM HR_ORGANIZATION_UNITS hou
339: , HR_ORGANIZATION_INFORMATION hoi1
340: , HR_ORGANIZATION_INFORMATION hoi2
341: , HR_LOCATIONS loc
342: WHERE hou.business_group_id = p_business_group_id
343: and hoi1.organization_id = hou.organization_id
344: and hou.location_id = loc.LOCATION_ID(+)

Line 359: , HR_ORGANIZATION_INFORMATION hoi1

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

Line 360: , HR_ORGANIZATION_INFORMATION hoi2

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

Line 377: , HR_ORGANIZATION_INFORMATION hoi1

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

Line 378: , HR_ORGANIZATION_INFORMATION hoi2

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

Line 614: , HR_ORGANIZATION_INFORMATION hoi1

610: ,hoi2.ORG_INFORMATION2 EMP_GRP
611: ,hoi2.ORG_INFORMATION3 WORK_HOURS
612: ,hoi2.ORG_INFORMATION4 FREQ
613: FROM HR_ORGANIZATION_UNITS hou
614: , HR_ORGANIZATION_INFORMATION hoi1
615: , HR_ORGANIZATION_INFORMATION hoi2
616: WHERE hou.business_group_id = p_business_group_id
617: and hoi1.organization_id = hou.organization_id
618: and hoi1.organization_id = p_le_id

Line 615: , HR_ORGANIZATION_INFORMATION hoi2

611: ,hoi2.ORG_INFORMATION3 WORK_HOURS
612: ,hoi2.ORG_INFORMATION4 FREQ
613: FROM HR_ORGANIZATION_UNITS hou
614: , HR_ORGANIZATION_INFORMATION hoi1
615: , HR_ORGANIZATION_INFORMATION hoi2
616: WHERE hou.business_group_id = p_business_group_id
617: and hoi1.organization_id = hou.organization_id
618: and hoi1.organization_id = p_le_id
619: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 633: , HR_ORGANIZATION_INFORMATION hoi1

629: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
630: ,hoi2.ORG_INFORMATION3 HOURLY_ACCR_RATE
631: ,hoi2.ORG_INFORMATION4 SAL_ALLOW_RATE
632: FROM HR_ORGANIZATION_UNITS hou
633: , HR_ORGANIZATION_INFORMATION hoi1
634: , HR_ORGANIZATION_INFORMATION hoi2
635: WHERE hou.business_group_id = p_business_group_id
636: and hoi1.organization_id = hou.organization_id
637: and hoi1.organization_id = p_le_id

Line 634: , HR_ORGANIZATION_INFORMATION hoi2

630: ,hoi2.ORG_INFORMATION3 HOURLY_ACCR_RATE
631: ,hoi2.ORG_INFORMATION4 SAL_ALLOW_RATE
632: FROM HR_ORGANIZATION_UNITS hou
633: , HR_ORGANIZATION_INFORMATION hoi1
634: , HR_ORGANIZATION_INFORMATION hoi2
635: WHERE hou.business_group_id = p_business_group_id
636: and hoi1.organization_id = hou.organization_id
637: and hoi1.organization_id = p_le_id
638: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'