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 339: FROM HR_ORGANIZATION_UNITS hou

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

Line 359: FROM HR_ORGANIZATION_UNITS hou

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

Line 377: FROM HR_ORGANIZATION_UNITS hou

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

Line 641: FROM HR_ORGANIZATION_UNITS hou

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

Line 660: FROM HR_ORGANIZATION_UNITS hou

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