APPS.PER_KW_XDO_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 27: FROM hr_all_organization_units org

23: rec_get_bg_id csr_get_bg_id%ROWTYPE;
24: CURSOR csr_get_org_id IS
25: SELECT org.organization_id
26: ,org.name
27: FROM hr_all_organization_units org
28: ,hr_organization_information hoi
29: WHERE org.organization_id IN (SELECT pose.organization_id_child
30: FROM per_org_structure_elements pose
31: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child

Line 46: FROM hr_all_organization_units org

42: AND hoi.org_information1 = 'HR_LEGAL_EMPLOYER'
43: UNION
44: SELECT org.organization_id
45: ,org.name
46: FROM hr_all_organization_units org
47: ,hr_organization_information hoi
48: WHERE org.organization_id = NVL(p_legal_employer,org.organization_id)
49: AND org.business_group_id = l_business_group_id
50: AND p_org_structure_version_id IS NULL

Line 79: ,hr_all_organization_units org

75: ,per_periods_of_service period
76: ,hr_lookups hr1
77: ,hr_lookups hr2
78: ,hr_lookups hr3
79: ,hr_all_organization_units org
80: --,hr_all_organization_units emp
81: ,hr_soft_coding_keyflex hsck
82: WHERE assg.person_id = people.person_id
83: AND assg.assignment_type = 'E'

Line 80: --,hr_all_organization_units emp

76: ,hr_lookups hr1
77: ,hr_lookups hr2
78: ,hr_lookups hr3
79: ,hr_all_organization_units org
80: --,hr_all_organization_units emp
81: ,hr_soft_coding_keyflex hsck
82: WHERE assg.person_id = people.person_id
83: AND assg.assignment_type = 'E'
84: AND (l_date) BETWEEN assg.effective_start_date

Line 536: FROM hr_all_organization_units org

532: rec_get_bg_id csr_get_bg_id%ROWTYPE;
533: CURSOR csr_get_org_id IS
534: SELECT org.organization_id
535: ,org.name
536: FROM hr_all_organization_units org
537: ,hr_organization_information hoi
538: WHERE org.organization_id IN (SELECT pose.organization_id_child
539: FROM per_org_structure_elements pose
540: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child

Line 555: FROM hr_all_organization_units org

551: AND hoi.org_information1 = 'HR_LEGAL_EMPLOYER'
552: UNION
553: SELECT org.organization_id
554: ,org.name
555: FROM hr_all_organization_units org
556: ,hr_organization_information hoi
557: WHERE org.organization_id = NVL(p_legal_employer,org.organization_id)
558: AND org.business_group_id = l_business_group_id
559: AND p_org_structure_version_id IS NULL

Line 578: ,hr_all_organization_units org

574: ,per_all_people_f people
575: ,per_contracts cont
576: ,per_jobs job
577: ,per_periods_of_service period
578: ,hr_all_organization_units org
579: ,hr_soft_coding_keyflex hsck
580: WHERE assg.person_id = people.person_id
581: AND assg.contract_id = cont.contract_id
582: AND assg.assignment_type = 'E'