[Home] [Help]
838: select *
839: from hr_soft_coding_keyflex kf
840: where exists
841: (select null
842: from hr_all_organization_units org
843: where org.organization_id = p_business_group_id
844: and org.soft_coding_keyflex_id = kf.soft_coding_keyflex_id);
845: --
846: v_scl_rec csr_bg_scl_segs%rowtype;