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

Line 231: , HR_ORGANIZATION_INFORMATION hoi1

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
235: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)

Line 232: , HR_ORGANIZATION_INFORMATION hoi2

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
235: and hou1.organization_id = nvl(p_sender_id ,hou1.organization_id)
236: and hou1.location_id = loc.LOCATION_ID(+)

Line 257: , HR_ORGANIZATION_INFORMATION hoi1

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
261: and hoi1.organization_id = hou.organization_id

Line 258: , HR_ORGANIZATION_INFORMATION hoi2

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
261: and hoi1.organization_id = hou.organization_id
262: and hou.location_id = loc.LOCATION_ID(+)

Line 278: , HR_ORGANIZATION_INFORMATION hoi1

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
282: and hoi1.organization_id = p_le_id

Line 279: , HR_ORGANIZATION_INFORMATION hoi2

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
282: and hoi1.organization_id = p_le_id
283: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 296: , HR_ORGANIZATION_INFORMATION hoi1

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
300: and hoi1.organization_id = p_business_group_id

Line 297: , HR_ORGANIZATION_INFORMATION hoi2

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
300: and hoi1.organization_id = p_business_group_id
301: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 476: , HR_ORGANIZATION_INFORMATION hoi1

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
480: and hoi1.organization_id = p_le_id

Line 477: , HR_ORGANIZATION_INFORMATION hoi2

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
480: and hoi1.organization_id = p_le_id
481: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 495: , HR_ORGANIZATION_INFORMATION hoi1

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
499: and hoi1.organization_id = p_le_id

Line 496: , HR_ORGANIZATION_INFORMATION hoi2

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
499: and hoi1.organization_id = p_le_id
500: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

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

504: and hoi2.organization_id = hoi1.organization_id
505: and p_effective_date BETWEEN hou.DATE_FROM and nvl(hou.DATE_TO, p_effective_date);
506:
507: /* Cursor to fetch the HR Org level Production Unit Code*/
508: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
509: IS
510: SELECT hoi2.ORG_INFORMATION6
511: FROM hr_organization_information hoi1
512: , hr_organization_information hoi2

Line 511: FROM hr_organization_information hoi1

507: /* Cursor to fetch the HR Org level Production Unit Code*/
508: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
509: IS
510: SELECT hoi2.ORG_INFORMATION6
511: FROM hr_organization_information hoi1
512: , hr_organization_information hoi2
513: WHERE hoi1.organization_id = hoi2.organization_id
514: AND hoi1.organization_id = hr_org_id
515: AND hoi1.org_information1 = 'HR_ORG'

Line 512: , hr_organization_information hoi2

508: CURSOR csr_get_hr_org_info(hr_org_id hr_organization_information.organization_id%type)
509: IS
510: SELECT hoi2.ORG_INFORMATION6
511: FROM hr_organization_information hoi1
512: , hr_organization_information hoi2
513: WHERE hoi1.organization_id = hoi2.organization_id
514: AND hoi1.organization_id = hr_org_id
515: AND hoi1.org_information1 = 'HR_ORG'
516: AND hoi1.org_information_context = 'CLASS'