DBA Data[Home] [Help]

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on DUAL

Line 218: from dual

214: and ose.organization_id_parent = P_TOP_ORGANIZATION_ID
215:
216: UNION
217: select P_TOP_ORGANIZATION_ID organization_id
218: from dual
219: order by organization_id;
220:
221: cursor get_organizations
222: ( P_ORG_STRUCTURE_VERSION_ID NUMBER

Line 236: from dual

232: start with ose.organization_id_parent = P_ORGANIZATION_ID
233: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID
234: UNION
235: select P_ORGANIZATION_ID organization_id
236: from dual
237: where P_ROLL_UP = 'Y'
238: UNION
239: select P_ORGANIZATION_ID organization_id
240: from dual

Line 240: from dual

236: from dual
237: where P_ROLL_UP = 'Y'
238: UNION
239: select P_ORGANIZATION_ID organization_id
240: from dual
241: where P_ROLL_UP = 'N';
242:
243: --Bug :2508617
244: --Ghanshyam