DBA Data[Home] [Help]

APPS.BEN_XCV_BUS dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 500: from hr_all_organization_units_vl org

496: and per.business_group_id = p_business_group_id;
497: --
498: cursor c3 (p_business_group_id number) is
499: select null
500: from hr_all_organization_units_vl org
501: where org.organization_id = l_number
502: and org.internal_external_flag = 'INT'
503: and p_effective_date between org.date_from
504: and nvl(org.date_to,p_effective_date)