DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT dependencies on DUAL

Line 359: from dual

355: start with ose.organization_id_parent = P_ORGANIZATION_ID
356: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID
357: UNION
358: select P_ORGANIZATION_ID organization_id
359: from dual
360: where P_ROLL_UP = 'Y'
361: UNION
362: select P_ORGANIZATION_ID organization_id
363: from dual

Line 363: from dual

359: from dual
360: where P_ROLL_UP = 'Y'
361: UNION
362: select P_ORGANIZATION_ID organization_id
363: from dual
364: where P_ROLL_UP = 'N';
365:
366: --bug 6124652 starts here
367: cursor get_assignment_start_end_fte