APPS.PER_KW_XDO_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 28: ,hr_organization_information hoi

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
32: AND pose.org_structure_version_id = p_org_structure_version_id

Line 47: ,hr_organization_information hoi

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
51: AND org.organization_id = hoi.organization_id

Line 537: ,hr_organization_information hoi

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
541: AND pose.org_structure_version_id = p_org_structure_version_id

Line 556: ,hr_organization_information hoi

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
560: AND org.organization_id = hoi.organization_id