APPS.HXC_PREFERENCE_EVALUATION dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 12: org_version_id per_org_structure_versions.org_structure_version_id%type,

8: -- will use PL/SQL tables in various places to manipulate preference information
9:
10: TYPE t_str_version_row IS RECORD
11: ( org_Structure_id per_organization_structures.organization_structure_id%TYPE,
12: org_version_id per_org_structure_versions.org_structure_version_id%type,
13: time_info date);
14:
15: TYPE t_requested_pref IS RECORD
16: ( code hxc_pref_definitions.code%TYPE,

Line 3368: from per_org_structure_versions

3364: return number is
3365:
3366: cursor c_version_id(p_number number) is
3367: select org_structure_version_id
3368: from per_org_structure_versions
3369: where organization_structure_id = p_number
3370: and trunc(sysdate) between nvl(date_from,trunc(sysdate)) and
3371: nvl(date_to,sysdate);
3372: