APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_TAX_UNITS_V

Line 1401: from hr_tax_units_v txu

1397: --
1398: cursor c_LegalEntityNameLovVO(p_source_name1 varchar2, cv_effective_date date) is
1399: select txu.name name,
1400: txu.tax_unit_id id
1401: from hr_tax_units_v txu
1402: where trunc(cv_effective_date)
1403: between Date_from and nvl(Date_to, trunc(cv_effective_date))
1404: and p_target_business_group_id = txu.business_group_id
1405: and txu.name = p_source_name1;