DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 3496: from per_org_structure_versions osv

3492: l_org_str_ver_id number;
3493: begin
3494: select osv.org_structure_version_id
3495: into l_org_str_ver_id
3496: from per_org_structure_versions osv
3497: where osv.organization_structure_id = p_organization_structure_id
3498: and osv.date_from = p_date_from
3499: and osv.version_number = p_version_number
3500: and osv.business_group_id + 0 = p_business_group_id;

Line 4043: from per_org_structure_versions osv

4039: l_ovn number;
4040: begin
4041: select osv.object_version_number
4042: into l_ovn
4043: from per_org_structure_versions osv
4044: where osv.organization_structure_id = p_organization_structure_id
4045: and osv.date_from = p_date_from
4046: and osv.version_number = p_version_number
4047: and osv.business_group_id + 0 = p_business_group_id;