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_UNITS

Line 313: FROM HR_ORGANIZATION_UNITS hou1

309: ,hou1.name NAME
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

Line 338: FROM HR_ORGANIZATION_UNITS hou

334: ,hou.name NAME
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

Line 358: FROM HR_ORGANIZATION_UNITS hou

354: /* Cursor to fetch the Legal Employer DA Office Codes */
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

Line 376: FROM HR_ORGANIZATION_UNITS hou

372:
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

Line 613: FROM HR_ORGANIZATION_UNITS hou

609: SELECT hoi2.ORG_INFORMATION1 COND_OF_EMP
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

Line 632: FROM HR_ORGANIZATION_UNITS hou

628: CURSOR csr_get_hol_entit(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
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