APPS.PAY_SE_INCOME_STATEMENT dependencies on HR_ORGANIZATION_UNITS

Line 353: FROM hr_organization_units o1

349: IS
350: /* select o1.NAME legal_employer_name
351: , hoi2.org_information2 org_number
352: , hoi1.organization_id legal_id
353: FROM hr_organization_units o1
354: , hr_organization_information hoi1
355: , hr_organization_information hoi2
356: , hr_organization_units o2
357: , hr_organization_information hoi3

Line 356: , hr_organization_units o2

352: , hoi1.organization_id legal_id
353: FROM hr_organization_units o1
354: , hr_organization_information hoi1
355: , hr_organization_information hoi2
356: , hr_organization_units o2
357: , hr_organization_information hoi3
358: WHERE o1.business_group_id = g_business_group_id
359: AND hoi1.organization_id = o1.organization_id
360: AND hoi1.organization_id = NVL(csr_v_legal_employer_id,hoi1.organization_id)

Line 372: FROM hr_organization_units o1

368: SELECT o1.NAME legal_employer_name
369: ,o1.location_id
370: ,hoi2.org_information2 org_number
371: ,hoi1.organization_id legal_id
372: FROM hr_organization_units o1
373: ,hr_organization_information hoi1
374: ,hr_organization_information hoi2
375: ,hr_organization_information hoi3
376: WHERE o1.business_group_id = g_business_group_id

Line 404: FROM hr_organization_units hou

400: ,hl.town_or_city
401: ,hl.region_1
402: ,hl.region_2
403: ,ft.territory_short_name
404: FROM hr_organization_units hou
405: ,hr_locations hl
406: ,fnd_territories_vl ft
407: WHERE hl.location_id = csr_v_location_id
408: AND hl.country = ft.territory_code;

Line 2021: FROM hr_organization_units o1

2017: ))
2018: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2019: AND scl.segment2 IN (
2020: SELECT o1.organization_id
2021: FROM hr_organization_units o1
2022: ,hr_organization_information hoi1
2023: ,hr_organization_information hoi2
2024: ,hr_organization_information hoi3
2025: WHERE o1.business_group_id = g_business_group_id

Line 2095: FROM hr_organization_units o1

2091: )
2092: IS
2093: SELECT o1.NAME
2094: ,hoi2.org_information2
2095: FROM hr_organization_units o1
2096: ,hr_organization_information hoi1
2097: ,hr_organization_information hoi2
2098: WHERE o1.business_group_id = g_business_group_id
2099: AND hoi1.organization_id = o1.organization_id

Line 2165: FROM hr_organization_units o1

2161: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2162: )
2163: IS
2164: SELECT 'Y' "VALID"
2165: FROM hr_organization_units o1
2166: ,hr_organization_information hoi1
2167: ,hr_organization_information hoi2
2168: ,hr_organization_information hoi3
2169: WHERE o1.business_group_id = g_business_group_id