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 2036: FROM hr_organization_units o1

2032: ))
2033: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2034: AND scl.segment2 IN (
2035: SELECT o1.organization_id
2036: FROM hr_organization_units o1
2037: ,hr_organization_information hoi1
2038: ,hr_organization_information hoi2
2039: ,hr_organization_information hoi3
2040: WHERE o1.business_group_id = g_business_group_id

Line 2110: FROM hr_organization_units o1

2106: )
2107: IS
2108: SELECT o1.NAME
2109: ,hoi2.org_information2
2110: FROM hr_organization_units o1
2111: ,hr_organization_information hoi1
2112: ,hr_organization_information hoi2
2113: WHERE o1.business_group_id = g_business_group_id
2114: AND hoi1.organization_id = o1.organization_id

Line 2180: FROM hr_organization_units o1

2176: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2177: )
2178: IS
2179: SELECT 'Y' "VALID"
2180: FROM hr_organization_units o1
2181: ,hr_organization_information hoi1
2182: ,hr_organization_information hoi2
2183: ,hr_organization_information hoi3
2184: WHERE o1.business_group_id = g_business_group_id