60: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
61:
62: CURSOR l_report_all_csr(cp_organization_id IN NUMBER) IS
63: SELECT id 64: FROM okc_k_headers_v 65: WHERE authoring_org_id = cp_organization_id
66: AND scs_code = 'LEASE';
67: BEGIN
68: --get organization id