APPS.PAY_SE_TRNA_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 250: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

246: CURSOR csr_legal_employer_details (
247: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
248: ) IS
249: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
250: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
251: WHERE o1.business_group_id = g_business_group_id
252: AND hoi1.organization_id = o1.organization_id
253: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
254: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 381: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

377: CURSOR csr_legal_employer_details (
378: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
379: ) IS
380: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
381: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
382: WHERE o1.business_group_id = g_business_group_id
383: AND hoi1.organization_id = o1.organization_id
384: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
385: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 397: hr_organization_units hou,

393: SELECT papf.person_id, paaf.assignment_id, papf.full_name, papf.national_identifier, paaf.assignment_number,
394: paaf.employment_category, hsck.segment15 div_code, hsck.segment14 area_code
395: FROM per_all_assignments_f paaf,
396: hr_soft_coding_keyflex hsck,
397: hr_organization_units hou,
398: hr_organization_information hoi,
399: per_all_people_f papf
400: WHERE papf.person_id BETWEEN p_start_person AND p_end_person
401: AND g_report_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date