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

Line 213: , HR_ORGANIZATION_INFORMATION hoi1

209: -- Cursor for getting the Insurance Number
210: CURSOR csr_Insurance_Number(csr_v_legal_employer_id NUMBER) is
211: select /*o1.NAME LU_NAME,*/ hoi2.ORG_INFORMATION6 Insurance_Number
212: from HR_ORGANIZATION_UNITS o1
213: , HR_ORGANIZATION_INFORMATION hoi1
214: , HR_ORGANIZATION_INFORMATION hoi2
215: WHERE o1.business_group_id = g_business_group_id --3133
216: and hoi1.organization_id = o1.organization_id
217: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER' --'SE_LOCAL_UNIT'

Line 214: , HR_ORGANIZATION_INFORMATION hoi2

210: CURSOR csr_Insurance_Number(csr_v_legal_employer_id NUMBER) is
211: select /*o1.NAME LU_NAME,*/ hoi2.ORG_INFORMATION6 Insurance_Number
212: from HR_ORGANIZATION_UNITS o1
213: , HR_ORGANIZATION_INFORMATION hoi1
214: , HR_ORGANIZATION_INFORMATION hoi2
215: WHERE o1.business_group_id = g_business_group_id --3133
216: and hoi1.organization_id = o1.organization_id
217: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER' --'SE_LOCAL_UNIT'
218: and hoi1.org_information_context = 'CLASS'

Line 231: , HR_ORGANIZATION_INFORMATION hoi1

227: )
228: is
229: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
230: from HR_ORGANIZATION_UNITS o1
231: , HR_ORGANIZATION_INFORMATION hoi1
232: , HR_ORGANIZATION_INFORMATION hoi2
233: WHERE o1.business_group_id = g_business_group_id
234: and hoi1.organization_id = o1.organization_id
235: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 232: , HR_ORGANIZATION_INFORMATION hoi2

228: is
229: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
230: from HR_ORGANIZATION_UNITS o1
231: , HR_ORGANIZATION_INFORMATION hoi1
232: , HR_ORGANIZATION_INFORMATION hoi2
233: WHERE o1.business_group_id = g_business_group_id
234: and hoi1.organization_id = o1.organization_id
235: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
236: and hoi1.org_information_context = 'CLASS'

Line 384: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

380: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
381: AND primary_flag='Y';*/
382:
383: CURSOR csr_legal_employer_details (
384: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
385: )
386: IS
387: SELECT o1.NAME legal_employer_name
388: -- , hoi2.org_information2 org_number

Line 391: , hr_organization_information hoi1

387: SELECT o1.NAME legal_employer_name
388: -- , hoi2.org_information2 org_number
389: -- , hoi1.organization_id legal_id
390: FROM hr_organization_units o1
391: , hr_organization_information hoi1
392: , hr_organization_information hoi2
393: WHERE o1.business_group_id = g_business_group_id
394: AND hoi1.organization_id = o1.organization_id
395: AND hoi1.organization_id = csr_v_legal_employer_id

Line 392: , hr_organization_information hoi2

388: -- , hoi2.org_information2 org_number
389: -- , hoi1.organization_id legal_id
390: FROM hr_organization_units o1
391: , hr_organization_information hoi1
392: , hr_organization_information hoi2
393: WHERE o1.business_group_id = g_business_group_id
394: AND hoi1.organization_id = o1.organization_id
395: AND hoi1.organization_id = csr_v_legal_employer_id
396: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 454: , hr_organization_information hoi1

450: hr_organization_units.organization_id%TYPE)
451: IS
452: SELECT hoi2.ORG_INFORMATION1 local_unit_id
453: FROM hr_organization_units o1
454: , hr_organization_information hoi1
455: , hr_organization_information hoi2
456: WHERE o1.business_group_id =g_business_group_id
457: AND hoi1.organization_id = o1.organization_id
458: AND hoi1.organization_id = csr_v_legal_unit_id

Line 455: , hr_organization_information hoi2

451: IS
452: SELECT hoi2.ORG_INFORMATION1 local_unit_id
453: FROM hr_organization_units o1
454: , hr_organization_information hoi1
455: , hr_organization_information hoi2
456: WHERE o1.business_group_id =g_business_group_id
457: AND hoi1.organization_id = o1.organization_id
458: AND hoi1.organization_id = csr_v_legal_unit_id
459: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 465: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

461: AND o1.organization_id =hoi2.organization_id
462: AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS';
463:
464: CURSOR csr_local_unit_details (
465: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
466: )
467: IS
468: SELECT o1.NAME local_unit_name
469: -- , hoi2.org_information2 org_number

Line 472: , hr_organization_information hoi1

468: SELECT o1.NAME local_unit_name
469: -- , hoi2.org_information2 org_number
470: -- , hoi1.organization_id legal_id
471: FROM hr_organization_units o1
472: , hr_organization_information hoi1
473: , hr_organization_information hoi2
474: WHERE o1.business_group_id = g_business_group_id
475: AND hoi1.organization_id = o1.organization_id
476: AND hoi1.organization_id = csr_v_local_unit_id

Line 473: , hr_organization_information hoi2

469: -- , hoi2.org_information2 org_number
470: -- , hoi1.organization_id legal_id
471: FROM hr_organization_units o1
472: , hr_organization_information hoi1
473: , hr_organization_information hoi2
474: WHERE o1.business_group_id = g_business_group_id
475: AND hoi1.organization_id = o1.organization_id
476: AND hoi1.organization_id = csr_v_local_unit_id
477: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'