DBA Data[Home] [Help]

APPS.PER_RI_CREATE_HIER_ELEMENT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 59: from per_organization_structures pos,per_org_structure_versions posv

55: Where batch_line_id = c_batch_line_id;
56:
57: Cursor csr_get_org_str_version_id (c_bg_id in number) Is
58: select posv.organization_structure_id
59: from per_organization_structures pos,per_org_structure_versions posv
60: where pos.organization_structure_id = posv.organization_structure_id
61: and (posv.business_group_id +0 = c_bg_id
62: or posv.business_group_id is null)
63: and name = p_org_str_version_user_key;