DBA Data[Home] [Help]

APPS.BEN_ECV_BUS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 441: from per_org_structure_versions osv

437: and egl.business_group_id = p_business_group_id;
438: -- Cursors for Set 1
439: cursor c_org_stru_ver is
440: select null
441: from per_org_structure_versions osv
442: where osv.business_group_id = p_business_group_id
443: and osv.org_structure_version_id = p_number_value1
444: and p_effective_date between osv.date_from
445: and nvl (osv.date_to, p_effective_date );

Line 474: from per_org_structure_versions osv

470: --
471: -- Cursors for Set 2
472: cursor c_org_stru_ver2 is
473: select null
474: from per_org_structure_versions osv
475: where osv.business_group_id = p_business_group_id
476: and osv.org_structure_version_id = p_number_value3
477: and p_effective_date between osv.date_from
478: and nvl (osv.date_to, p_effective_date );