DBA Data[Home] [Help]

APPS.PAY_ZA_EMP201 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 289: from hr_all_organization_units haou,

285: and l_effective_date between effective_start_date and effective_end_date;
286: */
287: CURSOR get_legal_entity_name(p_organization_id number)IS
288: select haou.name
289: from hr_all_organization_units haou,
290: hr_organization_information hoi,
291: hr_organization_information hoi2
292: where haou.organization_id = p_organization_id
293: and hoi.organization_id = haou.organization_id