DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 3469: from per_org_structure_versions osv

3465: l_org_str_ver_id number;
3466: begin
3467: select osv.org_structure_version_id
3468: into l_org_str_ver_id
3469: from per_org_structure_versions osv
3470: where osv.organization_structure_id = p_organization_structure_id
3471: and osv.date_from = p_date_from
3472: and osv.version_number = p_version_number
3473: and osv.business_group_id + 0 = p_business_group_id;

Line 4016: from per_org_structure_versions osv

4012: l_ovn number;
4013: begin
4014: select osv.object_version_number
4015: into l_ovn
4016: from per_org_structure_versions osv
4017: where osv.organization_structure_id = p_organization_structure_id
4018: and osv.date_from = p_date_from
4019: and osv.version_number = p_version_number
4020: and osv.business_group_id + 0 = p_business_group_id;