DBA Data[Home] [Help]

APPS.PO_CREATE_ISO dependencies on HR_ORGANIZATION_INFORMATION

Line 1002: FROM hr_organization_information src, hr_organization_information dest

998: -- get the from ou and to ou
999: -- Bug 7462235 - Changed org_information2 to org_information3 to fetch OU Id
1000: SELECT to_number(src.org_information3) src_ou, to_number(dest.org_information3) dest_ou
1001: INTO l_from_ou, l_to_ou
1002: FROM hr_organization_information src, hr_organization_information dest
1003: WHERE src.organization_id = l_src_org_id
1004: AND src.org_information_context = 'Accounting Information'
1005: AND dest.organization_id = l_dest_org_id
1006: AND dest.org_information_context = 'Accounting Information';