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 383: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

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

Line 390: , hr_organization_information hoi1

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

Line 391: , hr_organization_information hoi2

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

Line 453: , hr_organization_information hoi1

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

Line 454: , hr_organization_information hoi2

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

Line 464: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

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

Line 471: , hr_organization_information hoi1

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

Line 472: , hr_organization_information hoi2

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