14: and information11 like P_BATCH_NAME||'%';
15:
16: Cursor c_curr_date is
17: Select trunc(sysdate) 18: From dual; 19: cursor csr_org_struct_name IS
20: SELECT name
21: FROM per_organization_structures
22: WHERE organization_structure_id = p_org_structure_id;