DBA Data[Home] [Help]

APPS.CSTPMRGL dependencies on HR_ORGANIZATION_INFORMATION

Line 51: FROM hr_organization_information hoi

47: +---------------------------------------------------------------*/
48:
49: CURSOR all_ous(c_le_id NUMBER) is
50: SELECT distinct hoi.organization_id
51: FROM hr_organization_information hoi
52: WHERE hoi.org_information2 = to_char(c_le_id)
53: AND hoi.org_information_context = 'Operating Unit Information';
54:
55: /*-------------------------------------------------------------------+