DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_ORGANIZATION_UNITS

Line 1494: from hr_organization_units org

1490: --
1491: cursor c_PoplOrganizationLovVO(p_source_name1 varchar2, cv_effective_date date) is
1492: select org.name name,
1493: org.organization_id id
1494: from hr_organization_units org
1495: where trunc(cv_effective_date)
1496: between Date_from and nvl(Date_to, trunc(cv_effective_date))
1497: and org.business_group_id +0 = p_target_business_group_id
1498: and org.name = p_source_name1;