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.

[Home] [Help]

APPS.PAY_DK_ABSR_PKG dependencies on HR_ORGANIZATION_UNITS

Line 230: FROM HR_ORGANIZATION_UNITS hou1

226: ,hou1.name NAME
227: -- ,loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3 ADDR
228: ,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
229: ,loc.postal_code PCODE
230: FROM HR_ORGANIZATION_UNITS hou1
231: , HR_ORGANIZATION_INFORMATION hoi1
232: , HR_ORGANIZATION_INFORMATION hoi2
233: , HR_LOCATIONS loc
234: WHERE hou1.business_group_id = p_business_group_id

Line 256: FROM HR_ORGANIZATION_UNITS hou

252: ,hou.name NAME
253: -- ,loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3 ADDR
254: ,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
255: ,loc.postal_code PCODE
256: FROM HR_ORGANIZATION_UNITS hou
257: , HR_ORGANIZATION_INFORMATION hoi1
258: , HR_ORGANIZATION_INFORMATION hoi2
259: , HR_LOCATIONS loc
260: WHERE hou.business_group_id = p_business_group_id

Line 277: FROM HR_ORGANIZATION_UNITS hou

273: /* Cursor to fetch the Legal Employer DA Office Codes */
274: /* Modified check on context for bug fix 4997786 */
275: CURSOR csr_get_le_da_off_codes(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
276: SELECT hoi2.ORG_INFORMATION1 DA_SCODE
277: FROM HR_ORGANIZATION_UNITS hou
278: , HR_ORGANIZATION_INFORMATION hoi1
279: , HR_ORGANIZATION_INFORMATION hoi2
280: WHERE hou.business_group_id = p_business_group_id
281: and hoi1.organization_id = hou.organization_id

Line 295: FROM HR_ORGANIZATION_UNITS hou

291:
292: /* Cursor to fetch the Business Group Details */
293: CURSOR csr_get_bg_details(p_business_group_id NUMBER, p_effective_date DATE) IS
294: SELECT hoi2.ORG_INFORMATION1 DA_SYS_NO
295: FROM HR_ORGANIZATION_UNITS hou
296: , HR_ORGANIZATION_INFORMATION hoi1
297: , HR_ORGANIZATION_INFORMATION hoi2
298: WHERE hou.business_group_id = p_business_group_id
299: and hoi1.organization_id = hou.organization_id

Line 475: FROM HR_ORGANIZATION_UNITS hou

471: SELECT hoi2.ORG_INFORMATION1 COND_OF_EMP
472: ,hoi2.ORG_INFORMATION2 EMP_GRP
473: ,hoi2.ORG_INFORMATION3 WORK_HOURS
474: ,hoi2.ORG_INFORMATION4 FREQ
475: FROM HR_ORGANIZATION_UNITS hou
476: , HR_ORGANIZATION_INFORMATION hoi1
477: , HR_ORGANIZATION_INFORMATION hoi2
478: WHERE hou.business_group_id = p_business_group_id
479: and hoi1.organization_id = hou.organization_id

Line 494: FROM HR_ORGANIZATION_UNITS hou

490: CURSOR csr_get_hol_entit(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
491: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
492: ,hoi2.ORG_INFORMATION3 HOURLY_ACCR_RATE
493: ,hoi2.ORG_INFORMATION4 SAL_ALLOW_RATE
494: FROM HR_ORGANIZATION_UNITS hou
495: , HR_ORGANIZATION_INFORMATION hoi1
496: , HR_ORGANIZATION_INFORMATION hoi2
497: WHERE hou.business_group_id = p_business_group_id
498: and hoi1.organization_id = hou.organization_id