APPS.PER_ASG_BUS3 dependencies on HR_FR_ESTABLISHMENTS_V

Line 558: from hr_fr_establishments_v frv

554: and p_effective_date between date_from and nvl(date_to, p_effective_date);
555: --
556: cursor csr_estab_in_fr_estab_v is
557: select null
558: from hr_fr_establishments_v frv
559: where frv.organization_id = p_establishment_id
560: and frv.business_group_id = p_business_group_id;
561: --
562: begin