DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURE_VERSION_API dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 79: l_org_structure_version_id per_org_Structure_versions.org_structure_version_id%TYPE;

75: -- Declare cursors and local variables
76:
77: l_rowid VARCHAR2(20);
78: l_proc VARCHAR2(72) := g_package||'create_org_structure_version';
79: l_org_structure_version_id per_org_Structure_versions.org_structure_version_id%TYPE;
80: l_object_version_number per_org_structure_versions.object_version_number%TYPE;
81: l_effective_date date;
82: l_date_from date;
83: l_date_to date;

Line 80: l_object_version_number per_org_structure_versions.object_version_number%TYPE;

76:
77: l_rowid VARCHAR2(20);
78: l_proc VARCHAR2(72) := g_package||'create_org_structure_version';
79: l_org_structure_version_id per_org_Structure_versions.org_structure_version_id%TYPE;
80: l_object_version_number per_org_structure_versions.object_version_number%TYPE;
81: l_effective_date date;
82: l_date_from date;
83: l_date_to date;
84: --

Line 86: FROM PER_ORG_STRUCTURE_VERSIONS

82: l_date_from date;
83: l_date_to date;
84: --
85: cursor c is select rowid
86: FROM PER_ORG_STRUCTURE_VERSIONS
87: WHERE org_structure_version_id = l_Org_Structure_Version_Id;
88: --
89:
90: --