51: cursor CSR_ORG_STRUCT (
52: X_ORG_HIER_NAME in VARCHAR2
53: ) is
54: select POS.ORGANIZATION_STRUCTURE_ID
55: from PER_ORGANIZATION_STRUCTURES POS
56: where POS.NAME = X_ORG_HIER_NAME;
57:
58: cursor CSR_ORG_STRUCT_VER (
59: X_ORG_HIER_NAME in VARCHAR2,
59: X_ORG_HIER_NAME in VARCHAR2,
60: X_ORG_HIER_VERSION in NUMBER
61: ) is
62: select POSV.ORG_STRUCTURE_VERSION_ID
63: from PER_ORGANIZATION_STRUCTURES POS,
64: PER_ORG_STRUCTURE_VERSIONS POSV
65: where POS.NAME = X_ORG_HIER_NAME
66: and POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
67: and POSV.VERSION_NUMBER = X_ORG_HIER_VERSION;