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_SE_ALECTA dependencies on HR_ORGANIZATION_UNITS

Line 286: FROM hr_organization_units o1

282: IS
283: SELECT o1.NAME legal_employer_name
284: ,hoi2.org_information2 org_number
285: ,hoi1.organization_id legal_id
286: FROM hr_organization_units o1
287: ,hr_organization_information hoi1
288: ,hr_organization_information hoi2
289: WHERE o1.business_group_id = g_business_group_id
290: AND hoi1.organization_id = o1.organization_id

Line 1135: FROM hr_organization_units o1

1131: )
1132: IS
1133: SELECT o1.NAME
1134: ,hoi2.org_information1
1135: FROM hr_organization_units o1
1136: ,hr_organization_information hoi1
1137: ,hr_organization_information hoi2
1138: WHERE o1.business_group_id = g_business_group_id
1139: AND hoi1.organization_id = o1.organization_id

Line 2975: FROM hr_organization_units o1

2971: IS
2972: SELECT o1.NAME legal_employer_name
2973: ,hoi2.org_information2 org_number
2974: ,hoi1.organization_id legal_id
2975: FROM hr_organization_units o1
2976: ,hr_organization_information hoi1
2977: ,hr_organization_information hoi2
2978: WHERE o1.business_group_id = g_business_group_id
2979: AND hoi1.organization_id = o1.organization_id